AfriStatsXchange
AfriStatsXchange Report · 2026-11-15 11:43
GW since 2023 in JHB, EKH, TSH

Gauateng Waste · saved 2026-10-07

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.

Add a series on the left — the chart updates as you configure.
Inspect range

The dates Inspect reads usual levels from, apart from the chart's own dates. Empty: the chart's dates plus 6 periods either side — the usual level reads no further, so a wider range changes nothing. Narrow it to leave out months that were badly reported. Leads stay inside the chart's dates.

From
To
Data
Period t · GPR-00-512 t · GPR-00-699 t · GPR-02-015 t · GPR-02-111 t · GPR-02-262 t · GPR-02-607 t · GPR-02-612 t · GPR-02-735 t · GPR-02-876 t · GPR-03-480 t · GPR-05-094 t · GPR-05-589 t · GPR-05-633 t · GPR-09-581 t · GPR-10-965 t · GPR-10-970 t · GPR-12-274 t · GPR-12-631 t · GPR-13-759 t · GPR-18-656 t · Other
2024 104 062.36 45 807.39 40 775.41 900.85 106 685 62 443.42 152 811.87 112 862.61 54 910 77 353.40 47 522.44 74 455 117 470.35 138 538.59 632.09 236 156.17 445 421.85 130 480.34 127 754.08 1 318 769.04
2025 96 435.39 46 295.69 42 603.29 480.53 76 795 52 061.20 145 098.96 118 204.65 40 315.20 82 684.17 66 410.54 91 123 121 251.26 153 851.86 218 509.36 253 656.40 140 126.20 192 305.40 1 164 821.35
2026 79 297.53 28 092.79 96 149.26 156 504.84 43 626.13 64 797.80 120 359.89 58 563.77 28 798.76 54 751.75 27 325.35 70 435 91 108.37 117 447.43 2 224.37 210 650.78 20 030.00 88 276.32 133 176.37 201 332 820 377.89
Map

Each series sits on the map by its own dimension — points at its codes' locations, or their shapes — shaded by value or in the series' colour. Click one for that value on its own.

190 points on the map

AI insights

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.

2026-10-07 11:46 · Diederik de Roos

What Was Asked

This chart was built to analyze the annual trends and composition of waste generation in Gauteng’s major metropolitan areas—Johannesburg (JHB), Ekurhuleni (EKH), and Tshwane (TSH)—from 2024 through 2026. The objective was to track how specific waste categories (classified under GW codes) are changing over time, identify the primary drivers of waste volume in the region, and flag any notable anomalies or shifting patterns.

What the Chart Shows

The data reveals a general contraction in waste volumes across most categories between 2024 and 2026, alongside a few prominent anomalies and one distinct growth sector:

  • Dominant Categories: GW5301 remains the largest recorded waste stream by a significant margin, starting at 974,653.48 t in 2024, declining slightly to 920,834.57 t in 2025, and then dropping heavily to 466,113.13 t in 2026. The "Other" category also represents a massive share but shows a steep, continuous decline from 749,788.04 t in 2024 down to 266,824.51 t in 2026.
  • The 2025 Peaks: Several waste categories experienced isolated surges in 2025 before dropping sharply in 2026. Most notably, GW51 spiked from 88,884.56 t in 2024 to 254,452.54 t in 2025, only to plummet to 23,871.67 t by 2026. Similarly, GW14 peaked at 260,389.63 t and GW50 peaked at 100,427.38 t in 2025 before reverting to lower levels the following year.
  • Steady Growth: GW52 is the only category that shows consistent year-on-year growth throughout the period, expanding from 126,850.35 t in 2024 to 147,548.63 t in 2025, and rising significantly to 226,651.81 t in 2026.
  • Downward Trajectories: Categories like GW5002 (falling from 373,448.83 t to 238,119.96 t) and GW5101 (falling from 219,931.55 t to 31,909.41 t) highlight steady or sharp declines, indicating a reduction in these specific waste profiles over the three-year span.
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?

“GW since 2023 in JHB, EKH, TSH” 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 — “GW since 2023 in JHB, EKH, TSH” is left unchanged.

Name
You have unsaved changes

This chart no longer matches “GW since 2023 in JHB, EKH, TSH” as it is stored.
Load analysis

Loading replaces the current selection and renders the chart immediately.

Loading…
Source: AfriStatsXchange · https://asx.octoplus.co.za/analysis/chart/8dc4aeef-e778-40d1-a63b-a9dca86809cc