Running Total by Year
Best Answer
-
A couple of ways to go about this.
1) Build out the running total sums in an ETL and then use the period over period card.
2) Use the running total line card
Set your X axis to something like (Just change it to whatever timespan you want to look at)
CONCAT(MONTHNAME(`Date`),' Week ',WEEK(`Date`))
Set your value as the Y axis and then the Series to:
YEAR(`Date`)
If you only want to show through the current day (including the previous year, ie 2018-02-04)
Then add a filter that says:
CASE WHEN DAYOFYEAR(`Date`) <= DAYOFYEAR(CURRENT_DATE()) THEN 1 ELSE 0 END
And set it to 1.
Hope that helps,
Valiant
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.1
Answers
-
So under the Line chart type there is a 'Running Total Line'. Set that card up using your date column and value.
Now at the top right of the chart window, set the timeframe to 'This Year'. That will allow the running total line to continue to progress for the current year and then beginning next year it will reset.
Hope thats what you're looking for.
Sincerely,
Valiant
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
Is it possible to show more than one year? I would like to show 2018 full progression and 2019 resetting at 0.
0 -
A couple of ways to go about this.
1) Build out the running total sums in an ETL and then use the period over period card.
2) Use the running total line card
Set your X axis to something like (Just change it to whatever timespan you want to look at)
CONCAT(MONTHNAME(`Date`),' Week ',WEEK(`Date`))
Set your value as the Y axis and then the Series to:
YEAR(`Date`)
If you only want to show through the current day (including the previous year, ie 2018-02-04)
Then add a filter that says:
CASE WHEN DAYOFYEAR(`Date`) <= DAYOFYEAR(CURRENT_DATE()) THEN 1 ELSE 0 END
And set it to 1.
Hope that helps,
Valiant
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive