Report statistics
Use Statistics to inspect a range of chart data or compare two periods without exporting the report. For example, compare average daily cost before and after an infrastructure change, or inspect minimum, maximum, and average hourly costs.
Open Statistics
- Open a full report.
- Set View As to Stacked column and select one metric with Total aggregation.
- Use an Hour, Day, Week, Month, or Year time interval. Turn off secondary time ranges, forecast overlays, and comparison transformations.
- Select Statistics () in the chart toolbar.
The panel uses the report data already loaded and the series visible in the chart. Hiding a series in the legend updates the statistics. The panel is available in the full report, including fullscreen, but not in dashboard widgets or exports.
For Cost, Savings, and Margin, Statistics sums visible series within each chart interval. For Usage, extended metrics, and calculated metrics, show only one series in the legend. These metrics may contain ratios, rates, or different units, so Statistics provides their distribution without a total.
Inspect a range
Range initially shows statistics for the chart's visible time range. Choose a selection method:
- On chart: Drag across the columns to select complete intervals. A new drag replaces the selection. Selecting one column is also supported.
- Presets: Choose a range within the loaded report. Presets are unavailable when the report does not contain the required range. Hourly reports offer the last 24 or 168 hours; other intervals offer the last 7 or 14 intervals.
- Dates: Enter a start and end using the report's interval. Monthly reports select whole months, weekly reports select ISO weeks, and yearly reports select years. Hourly reports select complete hours, with minutes set to
00.
You cannot calculate daily statistics from monthly report data or minute-level statistics from hourly data. Change the report's time interval and run the report when you need finer detail.
Select Clear selection to return to the chart's visible range.
Compare two periods
- Select Compare. Period 1 is the initial selection target.
- Drag across the first period. The target switches to Period 2.
- Drag across the second period.
You can also use presets or enter dates for both periods. Periods can have different lengths or occur in either chronological order, but cannot overlap. Select a period's card to replace it, or use Swap periods to exchange them. Period 1 is always the comparison baseline.
The comparison table labels each statistic for P1 and P2. The Δ column shows P2 minus P1, with relative percentage change underneath. For example, a change from $500/day to $350/day is −$150/day, or −30%.
The headline defaults to the average per report interval. For additive metrics, switch to Totals to compare period sums. Totals also reflect differences in period length; averages normalize the number of included intervals. For ratio metrics, the average is the arithmetic mean of the interval values, not a weighted ratio across the period.
Positive and negative signs indicate direction. Cost increases appear red and decreases green; other metrics use neutral colors. Percentage-metric differences use percentage points. Relative change requires a positive baseline; otherwise it displays N/A.
Understand the statistics
| Statistic | Meaning |
|---|---|
| Total | Sum of included interval values; available for Cost, Savings, and Margin. |
| Average | Sum divided by the number of included intervals. |
| Median | Middle value after sorting; the mean of the two middle values for an even count. |
| Lowest / Highest | Minimum or maximum interval value. Hover over the date to see tied intervals. |
| P90 / P95 | Observed percentile using nearest rank: the value at position ceil(percentile × count) in sorted data. |
| Std deviation | Population standard deviation of the included interval values, in the metric's units. |
| Variability (CV) | Standard deviation divided by average, multiplied by 100. |
Use Variability (CV) to compare variation relative to average cost across periods with different spending levels. A higher CV means more variation relative to the mean. CV requires at least two intervals, a positive average, and no negative interval values; otherwise it displays N/A. Trends, credits, and partial intervals affect the result. These descriptive statistics are not forecasts or proof that a purchase caused savings.
The spread strip shows the observed minimum, maximum, median, percentiles, and a mean ±1 standard deviation band. Select How these are calculated for methodology and coverage details.
Coverage and exclusions
Statistics preserves the billing date and hour buckets already in the report. It does not apply a single report-wide timezone or convert provider billing timestamps.
Exclude latest report hour/day/week/month/year is off by default. When enabled, it excludes the final interval in the entire loaded report, identified beside the checkbox. It does not exclude the last interval of every selected period. The control is unavailable when that interval is outside your selection or has no usable values.
Explicit zero values are included. Intervals without usable visible values, missing intervals, and intervals marked incomplete are excluded. The panel shows included and excluded counts. Excluding the latest interval does not guarantee that the remaining billing data is complete. Boundary intervals may be partial; use the report's Exclude partial intervals setting when appropriate.
Copy, resize, and close
Select Copy as table to copy the displayed statistics, including comparison labels and changes. The checkmark confirms copying and returns to the copy icon shortly afterward.
Drag the panel's left edge to resize it, or focus the divider and use the arrow keys. Statistics and the series totals panel share the remembered width and display area.
Close Statistics with its close icon or Escape. Selections are temporary and are not saved with the report. Changing report data or activating chart zoom closes the panel.