When asking questions in the Q bar, we recommend phrasing them similarly to the following question types.
| Question Type | Example |
|---|---|
|
Dimensional Group Bys |
Revenue by product |
|
Dimensional Filters (Include) |
Sales for company |
|
Date Group Bys |
What is the weekly/monthly revenue trend? |
|
Multi Metrics |
What is actual revenue compared to goal? |
|
KPI-Based Period over Periods (PoPs) |
What is the revenue difference WoW? |
|
Relative Date Filters |
Show me revenue trend for the last 12 weeks |
|
Date Aggregation |
Show me revenue by quarter |
|
Time Range Filters |
How many new users do we have since Jan 2020? |
|
Top/Bottom Filter |
Top 10 customers by regional sales last week |
|
Period to Date (PtD) and Period over Period (PoP) |
Growth % in revenue YTD vs last year in California |
|
Non-KPI-Based Table Calculations |
Product with largest WoW growth % |
|
Sort Order |
Products with most revenue last week |
|
Aggregate Metrics Filter |
Customers who spent more than $1M last month |
|
List Questions |
Show me all opportunities created last month |
|
OR filters |
Show me defect that are open OR older than 3 months |
|
Percent of Total |
What is % of total revenue by product in 2018? |
|
Where Questions |
Where did we have the most sales in 2020? |
|
When Questions |
When did we have more than 50,000 in sales per week? |
|
Who Questions |
Who made the most sales last month? |
|
Exclude Questions |
Show me weekly sales excluding New York |
|
Boolean Questions |
Show me the count of open tickets |
|
Forecasting Questions |
Show me a forecast of sales for energy customers |
|
Why Questions |
Why did student enrollment drop in 2021 in the fall? |
|
Fragment Questions |
Sales details |
|
Explicit visual type |
Sales by region last week as a donut chart |
