Skip to main content
DocumentationLibraryReference
Cookbook
Prompt template
Everyone

Large values to review

The rows where a measure is above a cutoff, largest first, with the cutoff as a parameter.

Group
Filter the data
Blanks
Semantic model, Measure, Rows, Cutoff
Kater SQL
A number parameter in a filter on the measure

Prompt template

Fill in the blanks

Prompt
Use my Kater data to answer this question: Which should we review because is above ? --- Data: Measure: Use the measure as Kater defines it. Do not write its calculation again. List each of the where is above , largest first. Make the cutoff a number parameter, with as its default, so I can move it. Write a Kater SQL query, then run it. Show me the SQL, the result and one sentence on what stands out. If a name I gave does not match a field, show me the closest fields and ask me before you continue.

Fill in the blanks, then copy the prompt into the Ask panel in Kater or into your own agent (Connect your agent). A blank you leave empty stays in brackets, and your agent asks you for it.

What your agent does

  • Finds the semantic model, the measure and each other field you named. When a name does not match, it shows the closest fields and asks you.
  • Filters on the measure at the grouping you asked for, with the cutoff in a number parameter.
  • Runs the query and shows you the SQL, the result and one sentence on what stands out.

Example

For the Ad Reporting semantic model (ad_reporting), the question is:

Which campaigns should we review because Spend is above 10000?

Select Use the example to fill in every blank with it.