Calculating YoY and QoQ in Pivot Table
Hello,
I am trying to create a pivot table displaying QoQ and YoY revenue growth over the span of 6 quarters by product, but I am having difficulties building out the proper beastmode to show every quarter simulateanously. I have tried to use some suggested formulas (example: https://dojo.domo.com/t5/Domo-Dojo-Contest-January-2016/quot-Best-Beast-Mode-Formula-quot-Year-over-Year-Change/idi-p/7933) but it will not work for the previous quarters. Would anyone have any suggestions as to where I should start?
For the purpose of clarifying what I would like to design, I built out a simplistic practice pivot table attached below. Fairly new to the DOMO community, any help would be appreciated.
Thanks!
Best Answer
-
This is another case where it might be best to understande the question being asked rather than just the report being requested.
If you need to have the data displayed in a pivot table as you posted, then I do think you will need to make the calculations in a dataflow environment before building your card.
However, have you looked at the Period over Period chart options?
You could also get close using a flex table:
2
Answers
-
I think you will need to calculate your YoY and QoQ values in a dataflow. Let me know if you prefer to use MySQL dataflows or ETL and I can try to walk you through the steps.
Beastmode calculations are not able to look at multiple rows at a time (unless you are aggregating them, but then it can only look at one aggregate value at a time). I'm assuming your dataset has a separate row of data for each quarter for each product. If you ask the beastmode to look for Q1 2018, then it cannot also look for Q4 2017.
Hope that makes sense. The good news is you can calculate it in a dataflow.
0 -
This is another case where it might be best to understande the question being asked rather than just the report being requested.
If you need to have the data displayed in a pivot table as you posted, then I do think you will need to make the calculations in a dataflow environment before building your card.
However, have you looked at the Period over Period chart options?
You could also get close using a flex table:
2 -
Hello, apologies for the late response.
Although we would like to show the data through a pivot table view at some point, I think the flex table should work for what we are trying to accomplish at the moment. On your flex chart snapshot, how did you display the final three columns and calculations in your example? I am trying to go through the general chart properties, and I cannot seem to capture prior quarter values/QoQ % change.
Greatly appreciated, thank 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