Skip to main content
DocumentationLibraryReference
Cookbook
Prompt template
Everyone

What qualifies at a minimum

How many rows meet a proposed minimum, and their share of the total.

Group
Try a scenario
Blanks
Semantic model, Measure, Rows, Minimum
Kater SQL
A number parameter compared with the measure for each row

Prompt template

Fill in the blanks

Prompt
Use my Kater data to answer this question: How many would qualify if the minimum were ? --- Data: Measure: Use the measure as Kater defines it. Do not write its calculation again. Count the with at or above . Show what share of all , and of the total , they make up. Make the minimum a number parameter, with as its default, so I can try other minimums. 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.
  • Compares each row’s measure with the minimum, and gets the total from the measure itself.
  • 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:

How many campaigns would qualify if the minimum Spend were 1000?

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