Just Ask Search Inputs

Use the search inputs listed below when running queries on your data in the Just Ask search field.

The sections below describes supported search inputs and formats.

To achieve the best experience with Just Ask it is recommended that you refer to these supported inputs. It is also recommended that you use the provided sample questions or the alternative suggestions once you have executed your search. As a Natural Language Querying (NLQ) tool, Just Ask works best when measures, dimensions, supported formats, and keywords are used to search through the data.

Basic Questions and Simple Aggregations

Filters

Supported Question Types Sample Questions

Member dimension filters

  • Show me the revenue for Spain, Italy, and Portugal.

  • Show the product return rate on category for Electronics.

Excluding member dimension

  • Show me sales by country, but exclude France.

  • Show sales by store, except Supermarket.

Version filters

  • I'd like to see actual and forecast profit by product.

Measure filters

  • Show gross margin by location less than 10000;

  • I'd like to see gross margin by location > 10000;

  • Sales between 5k and 10k.

Time filters

  • Sales in 2026 by month

  • I'd like to see gross margin from 2022 to 2025.

  • Show sales by products until January 2026.

  • Gross margin year to date

  • Sales of last 4 years;

  • Show me the product sales by state for Q1 2026

Advanced Time Filtering

Supported Question Types Sample Questions

Multiple filters on the same date/time dimension

  • Gross Margin by Time for January 2026 and June 2025

  • Gross Margin by Time for 2022-2023 and 2025-2026

  • Gross Margin for Product by Time for January 2013 to June 2013 and Q4 2013

  • Sales by brand and date for January 2025 to June 2025 and Q4 2026

Fixed date ranges mixed with excluded date members

  • Taxes for 2025-2026 excluding feb 2025

  • Taxes for 2025 excluding q3 2025

  • Expense by date for 2024-2026 excluding feb 2024

Fixed date ranges mixed with dynamic date ranges

  • Taxes for 2025 and ytd

  • Expense for 2025 and ytd

Dynamic time filters

  • What are our taxes by month for last 4 years?

  • Show me expenses ytd

  • What are our taxes for this year and next 2 years?

  • Show me sales for 2025 and ytd

  • How were my sales last year compared to this year?

Fiscal vs calendar time periods

  • Show me sales by fiscal period

  • Show me sales by fiscal year

  • Show me sales in 2025 w10

  • What are our taxes by week for W10 2025 - W14 2026?

  • Sales for this fiscal year compared with last year

  • Show me taxes by calendar month

  • Show me taxes by calendar quarter

  • Cost of goods sold for P01 2025

  • Cost of goods sold for P02 2025 by week

  • What are the cost of goods sold by period for fiscal 2011?

Fiscal Time

  • Sales by period in fiscal year 2024

  • Sales in W10 2024

  • Sales in fiscal January

  • Sales in fiscal Q3

Dynamic Time Filters

  • Sales last year

  • Sales year to date

  • Sales from the previous year up to now

Ordering

Supported Question Types Sample Questions

Ranking

  • Show the top/worst 3 sales managers for this month.

  • I'd like to see the lowest/highest/bottom sales by product.

Ordering by measure or dimension

  • Sort sales by country in ascending order.

  • Sort sales by country in descending order.

  • Ascending sales by state.

  • Sales by ascending state.

Limiting the result

  • Let me see gross margin by location, limited to 20

Calculations

Supported Question Types Sample Questions

Basic calculation over one dimension aggregation

  • What’s the average sales by stores?

  • Show me max gross margin by location, excluding nulls.

  • Tell me the number of employees in my departement.

Percentage of total

  • How much does California contribute to total USA sales?

  • What percentage of total sales comes from Food and Drink?

Compound Annual Growth Rate (CAGR)

  • Show me the compound growth rate of sales from 2024 to 2025.

  • What is the CAGR of sales between 2024 and 2025?

  • Quarterly CGR of expenses from Q1 to Q2.

Comparison/Variance

Supported Question Types Sample Questions

Variance

  • What is the difference between sales and expense?

  • Compare actual vs forecast operating expenses by cost center.

  • Compare sales 2025 with 2024.

  • What is the revenue in 2026 vs Q1 2026?

  • Show this quarter’s sales compared to last quarter.

  • Show me the comparison of sales actual in 2025 vs forecast in Q1 2026.

  • Difference in sales for Canada and Mexico.

Variance Percentage

  • What is the percentage difference between sales and expense?

  • What is the % difference between sales and expense?

  • Difference in sales by percentage for Canada and Mexico.

Hierarchy

Supported Question Types Sample Questions

Hierarchy drilling

  • Show sales by date and drill down to level 2.

  • Give me the gross margin by location drill on California.

Model Reference

Supported Question Types Sample Questions

Query without selecting a model

  • Show unit per product last year from the Sales_SampleModel.

Currency

Supported Question Types Sample Questions

Currency Conversion

  • Show gross margin in EUR.

  • Show gross margin in USD.

Visualization

Supported Question Types Sample Questions

Charts definition

  • Show expense by product as a pie chart.

  • Let me see gross margin by location as line chart.

Current Restrictions

Restrictions Sample Questions

Calculations between measures (for example, sum or ratio) aren’t possible; this feature isn’t supported.

  • What is the sum of the sales and gross margin?

  • Show me profit in Germany divided by profit in Europe.

Predictive forecasts, such as projecting future trends, are not supported by the system.

Could I get a sales predictive forecast for the next quarter?

The system can’t process complex multi-step calculations or cross-dataset join.

  • Show me the sales from <Sales_SampleModel> and gross margin from <BestRunJuice_SampleModel>.

Asking for model metadata isn’t supported on this platform.

  • How many measures and dimensions are stored in this model?

  • Can you give me the list of entities for the Regions dimension?

Queries with timestamps (for example, exact date and time) aren't supported; filtering is limited to date-level granularity.

  • Show me the amount by date and time since <2025-06-14 21:59:00>.

The platform supports only English, Italian, French, German and Spanish, as long as the model is in the language of the question, this means that Just Ask won’t make translation on the fly.