Analyze & build in JustAsk

JustAsk’s analysis tools are centered around workbooks — flexible, multi-tab environments where you can query data, build calculations, and prepare results for visualization. This section covers everything you need to build analyses in JustAsk.

Query data

JustAsk supports multiple paths for querying your data, from conversational AI to point-and-click. Every query is routed through the semantic model, so results respect your organization’s definitions and permissions regardless of how you build them.

Upload additional data

Not all data lives in your data warehouse. JustAsk lets you upload CSV and Excel files directly into a workbook to use alongside your database queries — useful for one-off enrichments, manual data entry, or working with data that hasn’t made it into your pipelines yet.

Spreadsheets

Spreadsheet tabs bring an Excel-like environment into your workbooks. Connect spreadsheet tabs to your queries and use familiar formulas to format, reshape, and build on top of live data — without exporting or manually refreshing.

Calculations and custom fields

Extend your queries with ad hoc logic:

• Table calculations — Use Excel-style functions to create post-query metrics like percent of total, running totals, and period-over-period comparisons.
• Custom fields — Create reusable dimensions and measures with custom SQL or modeled objects, including bins and groups and filtered measures.