Below are some different ways to use the Data Assistant.
Query
Description | Request one or multiple Metrics |
|---|---|
Queries | “Show me Revenue” |
“Show me Revenue, EBITDA and OPEX” |
Breakdown
Description | Break down Metrics by any Dimension or Grouping Dimension |
|---|---|
Queries | “Break down Revenue by product and quarter” |
“Show me EBITDA by year and scenario” |
Sort
Description | Sort your query in ascending or descending order |
|---|---|
Queries | “EBITDA by country for EMEA and AMER, sort countries ascending” |
“Revenue by product, sort by highest first” |
Aggregate
Description | Aggregate results by removing Dimensions from the View |
|---|---|
Queries | “Exclude Country Dimension” |
“Remove Month Dimension” |
Filter by Item
Description | Filter Metrics by any item from Dimensions or Grouping Dimensions |
|---|---|
Queries | “Show me Revenue for EMEA and AMER regions” |
“Show me headcount for team HR in Jan 24” |
Filter by Metric value
Description | Specify values to filter on |
|---|---|
Queries | “Show me countries with EBITDA below 0” |
“Filter products with revenue > 100k€” | |
“Show me top 3 products in revenue for 2023 ranked highest to lowest” | |
“Filter on Functions with more than 10 headcount” |
Calculate
Description | Request difference, sum, ratio and growth between Items and Metrics |
|---|---|
Queries | “Show me revenue, headcount and ratio of revenue to headcount in 2024” |
“Show me revenue growth between this year and last year” | |
“Show me the difference in costs between France and Spain” |
Display
Description | Ask for Grid, KPI or Chart display. The following Chart types are available:
|
|---|---|
Queries | “Show a stacked bar chart of revenue for EMEA and AMER regions” |
“Show me revenue by quarter in a line chart” | |
“Compare revenue in 2022 and 2023 split by Country in a Waterfall Variation chart” |
Learn more
🎓 Pigment Academy
For detailed insights, examples and use cases on Pigment’s AI tools, explore the Pigment AI Learning Path.