What this helps you see
Accumulate flow observations such as revenue through time; adding price levels usually has no useful interpretation.
A practical use case
The example was computed with Datamon’s deterministic analysis function. Download the input to rerun the operation, and use the output CSV to verify what the figure displays. The calculation does not require a provider-backed AI service.
Free example data and exact column mapping
The figure uses the downloadable CSV with the exact column mapping below. Public snapshots retain their data notes and transformations. Constructed teaching scenarios are identified in the method notes; they are not customer results. Editorial layouts may combine comparisons from the same records.
The free example contains 60 observations and these columns: Date, S&P 500 index. Keep the header row and preserve one observation per row. The table below shows the first records; the CSV retains the full example.
Download analysis input CSVDownload free example CSV
| Date | S&P 500 index |
|---|---|
| 2020-01-01 | 100 |
| 2020-02-01 | 91.58895163615968 |
| 2020-03-01 | 80.12940773085735 |
| 2020-04-01 | 90.2933453832314 |
| 2020-05-01 | 94.38199236587486 |
| 2020-06-01 | 96.11752586527275 |
How to use it in Datamon
- Sign in with Google, create a visualization and import the free CSV in Data. Check numeric columns, date order, decimal separator and missing values against the example table.
- Open the analysis controls and choose the operation below. Use the stated input field, category and any comparison field. Review the result before applying the resulting visualization.
- cumulative · S&P 500 index · Date
- Keep the observation unit and reporting period explicit. Select the figure size before adjusting text, and check the chart at the size your reader will see.
Calculation and result
Cumulative total[t] = sum(valid observations through t)- Categories / X axis
- Period / category
- Values / Y axis
- cumulative S&P 500 index
How to read the example
Compare positions and values with the table, then inspect the legend or size encoding where used. A visual pattern is a description of the displayed observations. It does not by itself identify a cause, justify extrapolation, or repair missing data.
| Period / category | cumulative S&P 500 index |
|---|---|
| 2020-01-01 | 100 |
| 2020-02-01 | 191.5889516361597 |
| 2020-03-01 | 271.71835936701706 |
| 2020-04-01 | 362.0117047502485 |
| 2020-05-01 | 456.3936971161233 |
| 2020-06-01 | 552.511222981396 |
Refine and export the result
In Refine, edit the title, subtitle, axis descriptions, source and supported series settings. Use color to identify a comparison rather than to decorate every mark. Export SVG, PNG, JPEG, PDF or PowerPoint and inspect the actual file; save an editable project backup for revisions.
Limits and common mistakes
The result depends on the observation order, units and selected records. Zero denominators and incomplete pairs need explicit treatment. Do not turn a descriptive result into a forecast, and inspect the original observations before excluding an outlier.
What is free and what needs an account?
Reading this guide and downloading its CSV and chart images are free. Datamon currently has no paid checkout or subscription plans in this deployment. Creating and saving an editable visualization requires Google sign-in. Provider-backed AI, cloud analysis, publishing and video depend on configured services; this guide does not promise unlimited free connected services.
Questions before you start
Can I visualize cumulative totals with a free example?
Yes. The CSV and preview images on this page are free to download. Follow the field mapping and steps above. Sign in to create and save the editable project; connected-service availability is separate.
Can I replace the example with my own data?
Yes. Preserve the observation unit and the required numeric, category or geographic fields. Recompute any derived values, update the unit and source, and compare the output with known rows before sharing.
Sources and further reading
Report a correction or an access barrier: Email the editorial contact.
Open Datamon