How to create a chart with a rolling 12 month by month
Anyone have any ideas on how to create a chart with a rolling 12 month by month. I would like to create a chart similar to the attached in which for each month i have the rolling sum/count.
Thanks in advance for your help
Comments
-
Hi @user057102
building the card , in edit mode you should be able to select from the "Chart Types" > Vertical Bars , the one named "Running Total Bar". as well as setting the last 12 months by month in the date grain options
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
Hi @Godiepi
Thanks very much for your reply on this but this is not report me the desired result.
This card report the running total, i mean e.g. each month takes into account itself plus the result of the previous month, while I should calculate the total for the last 12 months for each month.For instance in September 2019 i have to calculate the number of distinct cusotmers active in the last 12 months so from October 2018 till September 2019, then in October 2019 will be number of distinct customers from November 2018 till October 2019.
Is this something achievable ?
Thanks again for your help
Danilo
0 -
Was there a solution to this? I am also trying to view the below in a table.
Month
Monthly Count
Rolling 12 Month Count
Comment
Oct-24
5
71
Oct-24 to Nov-23
Sep-24
6
71
Sep-224 to Oct-23
Aug-24
11
69
Aug-24 to Sep-23
Jul-24
7
66
Jun-24
9
63
May-24
2
54
Apr-24
3
52
Mar-24
9
49
Feb-24
4
40
Jan-24
6
36
Dec-23
1
30
Nov-23
8
29
Oct-23
5
21
Sep-23
4
16
Aug-23
8
12
Jul-23
4
4
0
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
- 747 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
- 126 Manage
- 123 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