AfriStatsXchange
Analyse, Customise & Explore Share
PDF – Portrait PDF – Landscape

The PDF could not be made. Try again, or use Print.

Chart copied — paste it into your document.

The chart could not be copied. Wait for it to draw and try again.

Charts and figures are calculated directly from the data. The commentary below is written by AI: it can misread the data or miss context, and is not a professional or official interpretation. Check important conclusions against the figures.

Series options

Settings for this series only. The dataset filters still apply to every series.

Configure period filter

One date window applied to every picked dataset's period column. Bucket sets how the time axis is grouped.

Bucket (X-axis grouping)

Please wait…

From
To
Until the last full period To stops at the end of the last finished period and moves on by itself: last Sunday for weeks, the last day of last month for months, last year for years, yesterday for days. Periods back leaves that many more out, for data that comes in late.

periods back

Switching the bucket reshapes an already-picked range to match it — month keeps the 1st/last day, year keeps Jan/Dec, sub-day buckets keep 00:00/23:59. Leave a side empty to use the earliest / latest observation.

Chats about this report

Your conversations that created this report or discuss it. Open one to continue where you left off.

Building a chart

A chart is one or more series plotted over a shared time axis. Every choice below stays editable after saving.

Series

Pick a measure from any dataset's concept list on the left to add it to Y. Series may come from different datasets — they all align on the same time axis. Each series has its own aggregate (sum, avg, min, max, count).

Split by

Splitting one series by a dimension (or CATEGORY) automatically fans it out into one sub-series per value — you don't need to add a series per value yourself. On a stacked bar each value becomes one segment of the pile; on a plain bar each value is its own grouped bar; on a line each value is its own separate line.

Stack

Only matters for stacked bars. Series sharing the same stack name pile into one column. Give a series a different stack name to put it in its own column next to the others — e.g. two separate stacked totals side by side on the same chart.

Axis

Left or right Y axis. Left blank, series sharing a unit share an axis automatically and the first unit takes the left. Set it explicitly when combining measures with different units, e.g. Kg on the left and R-million on the right.

Bucket, period & filters

Bucket sets the X-axis granularity (minute, hour, hour of day, day, week, month, year). Filters restrict a dataset to a dimension's values — use them to isolate the segment a question is about instead of charting everything. Tags are multi-valued, so a tag filter matches a row carrying ANY of the picked values, and splitting by a tag counts a row under each of its tags — per-tag figures are right, but they add up to more than the ungrouped total. The "Peak in a…" aggregates plot the busiest single minute/hour/day instead of the total, which is how a burst that a summed timeline flattens out shows up. Put a dimension on the X axis (e.g. operator) and the tallest bar is whoever concentrated the most activity into one window. The gap aggregates measure the seconds between each observation and the previous one in the same series — median, fastest, and how many arrived under 90 seconds apart. A steady machine-like cadence and a person working in clumps give the same totals; only the spacing tells them apart. Needs a dataset whose period kind is "Date & time", and a short gap is a question to ask about the source system, not a conclusion on its own.

Delete this report?

“South Africa Whey Production vs. Gauteng Food Waste (2022-2025)” and its saved view will be removed for good. This cannot be undone, and any shared link to it stops working.

Share with a person

They get their own private link by email, with the datasets this report is built from. The report itself stays private — publishing is a separate choice.

Their name
Their email address
Message (optional)
Save a copy

Saves the whole selection — series, aggregates, axes, splits, filters and period — plus the list of datasets it uses. This creates a new, separate analysis — “South Africa Whey Production vs. Gauteng Food Waste (2022-2025)” is left unchanged.

Name
You have unsaved changes

This chart no longer matches “South Africa Whey Production vs. Gauteng Food Waste (2022-2025)” as it is stored.

Load analysis

Loading replaces the current selection and renders the chart immediately.

Loading…