> ## Documentation Index > Fetch the complete documentation index at: https://learn.kubit.ai/llms.txt > Use this file to discover all available pages before exploring further. # Data Table report > Explore aggregated data in a table with up to 6 measures and 5 Group By dimensions, period comparison, heatmaps and CSV export in Kubit. A Data Table report shows aggregated data as a table, with more dimensions than a chart-based Query report allows. This page covers the Data Table report's settings: measures, Group By, Compare, time granularity and the table display options. ## When to use | Use case | Example | | - | - | | Multi-dimensional breakdown | Latency by model, environment, span type, trace name and error code, in one table (up to 5 dimensions) | | Data export | A structured dataset for offline analysis or for sharing with stakeholders | | Detailed comparison | This week's metrics next to last week's, column by column, with percent change | | Outlier spotting | A heatmap-colored table that shows which cells stand out across many dimension combinations | | Ad hoc exploration | Pivot across dimensions without picking a chart type | ### Data Table or a Query report's table view | Capability | Data Table | [Query report](https://learn.kubit.ai/product-analytics/reports/query.md) with [table view](https://learn.kubit.ai/product-analytics/reports/query/data-table-view.md) | | - | - | - | | Group By dimensions | Up to **5** | Up to **2** | | Measures per report | Up to **6** | **TBD** | | Column filtering, inline bars, heatmap coloring | **Yes** | **No** | | Formulas | **No** | **Yes** | ![Data Table report in the report builder: Count Events as Measure A, grouped by Span, with a table of span names, inline horizontal bars and each row's count and share of the 1,033,866 total.](https://mintcdn.com/kubit/9i8QHxqek50tMBGy/images/reports/data-table/data-table-report.png?fit=max\&auto=format\&n=9i8QHxqek50tMBGy\&q=85\&s=9ac8e595aa34ac8911030ca5f0950e60) ## Measures A measure is a function applied to a field. A Data Table report aggregates one or more measures. The measure functions are Count, Count Distinct, Sum, Avg, Min, Max and Percentile. | Constraint | Value | | - | - | | Max measures | **6** | ## Group By Group By sets the dimensions that make up the table's rows. Each unique combination of dimension values is one row. Each Group By field can have binning (Range, Enum, Date or Named) and its own filters. [Group By and binning](https://learn.kubit.ai/product-analytics/reports/common/group-by-and-binning.md) covers the binning options. | Constraint | Value | | - | - | | Max breakdown groups | **5** | | Max cohort segments | **5** | The limit of 5 groups is more than the 2 that Query reports allow, which makes Data Table the report for multi-dimensional exploration. ## Compare Compare puts the current period next to an earlier one. When you pick a comparison period, each measure column splits into current and previous values side by side. [Compare](https://learn.kubit.ai/product-analytics/reports/common/compare.md) covers comparison across report types. | Preset | Offset | | - | - | | **Previous Day** | 1 day back | | **Previous Week** | 1 week back | | **Previous Month** | 1 month back | | **Previous Quarter** | 1 quarter back | | **Previous Year** | 1 year back | A custom date is also available. ### Percent change When a comparison is on, turn on **Show % Change** to add a column with the relative change between the two periods. Increases show in green and decreases in red. ## Time granularity A Data Table report supports every time granularity, not only All Time. | Time unit | Aggregates by | | - | - | | **Hour** | Hour | | **Day** | Day | | **Week** | Week | | **Month** | Month | | **Quarter** | Quarter | | **Year** | Year | | **All Time** | The full date range | ## Table display The table has sorting, inline visualizations and CSV export. ### Column sorting Click a column header to sort the table by that column. Sorting works on text and numbers, ascending or descending. ### Inline visualizations | Feature | What it shows | | - | - | | Horizontal bars | A bar in each measure cell, sized relative to the other rows | | Heatmap coloring | Cells colored on a gradient by value, from low to high | ### Export To download the table as a CSV file, open the options menu (the three-dot icon) and click **Export as CSV**. ![Data Table report with the report options menu open in the header, showing Duplicate Report and Export as CSV.](https://mintcdn.com/kubit/9i8QHxqek50tMBGy/images/reports/data-table/export-csv.png?fit=max\&auto=format\&n=9i8QHxqek50tMBGy\&q=85\&s=a9a283971d8831f9d86016b30830d83c) ## MCP prompt examples A Data Table prompt for the Kubit MCP server names the measures, the Group By dimensions (up to 5) and the date range. Add the time granularity when it isn't All Time ("daily", "weekly", "monthly"), a comparison period ("compared to last week") when you need one, and any filters. > "Create a data table of event count by model name over the last 7 days" > "Build a data table of daily average latency and total cost by model name and environment for the last 30 days" > "Show me a data table of count distinct users, average latency, and P95 latency grouped by model, span type, trace name, environment, and status code over the last quarter" ## Related * [Query report](https://learn.kubit.ai/product-analytics/reports/query.md): chart a measure over time, with formulas. * [Filters](https://learn.kubit.ai/product-analytics/reports/common/filters.md): narrow the rows a Data Table report aggregates. * [Dashboards](https://learn.kubit.ai/product-analytics/dashboards.md): add a Data Table report to a dashboard. This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.