Skip to main content
DocumentationLibraryReference
Cookbook
Prompt template
Everyone

Share of the total

Each value’s part of the total, with the total from the measure itself.

Group
Compare in context
Blanks
Semantic model, Measure, Dimension
Kater SQL
EVAL(measure, REMOVE(dimension)) for the total

Prompt template

Fill in the blanks

Prompt
Use my Kater data to answer this question: How much does each contribute to the total ? --- Data: Measure: Use the measure as Kater defines it. Do not write its calculation again. Show for each , the total, and each share of the total as a percent. Get the total from the measure with removed from its grouping. Do not add up the rows of the result. 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.
  • Gets the total from the measure with the dimension removed, so each share stays correct when you filter or group the result.
  • 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 much does each Platform contribute to the total Spend?

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