How can I show % change summary # for Period over Period chart?
We have a lot of cards tracking current year vs prior and the period over period chart type works for the visualization, but is there a way to get the summary number to show the % change period over period? From what I can tell, if I set the date range to current period and then compare to prior period that limits my summary number to just current period data and therefore can't show the % change. I would think this would be a pretty common request / use case for period over period reporting. Thanks.
Best Answer
-
Hi @MattGo
Period over Period charts don’t support percent change. You’d need to calculate it yourself using a beast mode however it’s best to reformat your data using a date dimension table to calculate your metrics on a certain date based on a certain offset (Last Year, last month last week etc. ).
@jaeW_at_Onyx has a great video outlining the process https://www.youtube.com/watch?v=CDKNOmKClms&t=468s
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
Hi @MattGo
Period over Period charts don’t support percent change. You’d need to calculate it yourself using a beast mode however it’s best to reformat your data using a date dimension table to calculate your metrics on a certain date based on a certain offset (Last Year, last month last week etc. ).
@jaeW_at_Onyx has a great video outlining the process https://www.youtube.com/watch?v=CDKNOmKClms&t=468s
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Thanks Grant. Yes, we have utilized non-period over period charts and created Beast Modes to capture the % change. It just seems like % change should go hand-in-hand with period over period charts and it would be much simpler that way so I am surprised Domo did not give these charts that capability. Perhaps a good idea to suggest.
1 -
You can create a custom summary number to get this information. Here is what I wrote for one of my cards to show the trend.
ROUND(((SUM(CASE WHEN YEAR(`datereported`) = YEAR(CURRENT_DATE()) THEN 1 ELSE 0 END ) - SUM(CASE WHEN YEAR(`datereported`) = YEAR(CURRENT_DATE())-1 THEN 1 ELSE 0 END ))/ SUM(CASE WHEN YEAR(`datereported`) = YEAR(CURRENT_DATE())-1 THEN 1 ELSE 0 END ))*100,0),'%'
In my example, I looking for rows that meet the year criteria and applying a 1 or 0 and then summing up that to get the total rows. If you are needing dollars, you would replace the 1 with your amount field. You would also need to replace datereported with your date field.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
@MarkSnodgrass thanks for the reply. We utilize similar Beast Modes on other card types, but I don't think it works on the period over period charts because you essentially have to set the date range to current period, and then apply the "Compare to" option. Once that date range is selected for current period, you lose the ability to calculate % change in the summary number.
1 -
@MattGo good point. I pulled that example from a flex table card, which is what I often to use to compare prior years and I don't have to select the compare to previous year date option.
I agree that it would be nice if it was just a baked in option on the summary numbers, especially for period over period cards. Definitely worth submitting in the ideas exchange in the Dojo.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
this is the reason why i try to avoid using period over period cards and instead always recommend building your own date dimension that handles period comparisons for you.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
Jae Wilson,
I attempted to complete the same process with some data and the issue that I am seeing is when a month has 31 days, the following month previous does not sum that day and throws off the percent change from month to month. Any idea on what is the issue.
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
- 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