Cookbook
Prompt template
Everyone
What if a measure changes
A result beside the same result after one measure changes by an amount you select.
Prompt template
Fill in the blanks
Prompt
Use my Kater data to answer this question: What would be if changed by ?
---
Data:
Measure:
Use the measure as Kater defines it. Do not write its calculation again.
Show now and in the scenario, side by side, by .
Make the change a number parameter, with as its default, so I can try other amounts.
Use the Kater definition of every measure that the result reads.
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.
- Works out the scenario from the measures as Kater defines them, with the change 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:
What would return on ad spend, Conversion Value divided by Spend be if Spend changed by +15%?
Select Use the example to fill in every blank with it.