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
- What is Pigment AI?
- Configure your Workspace for the Data Assistant
- Features Supported by the Data Assistant
- Key Features of the Data Assistant