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/DomoDojoContestJanuary2016/quotBestBeastModeFormulaquotYearoverYearChange/idip/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:
______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” Superman
______________________________________________________________________________________________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.
______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” Superman
______________________________________________________________________________________________0 
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
 10.7K All Categories
 1 APAC User Group
 12 Welcome
 36 Domo News
 9.6K Using Domo
 1.9K Dataflows
 2.4K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 339 Workbench
 252 Domo Best Practices
 11 Domo Certification
 461 Domo Developer
 47 Domo Everywhere
 101 Apps
 705 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 23 お知らせ
 63 Kowaza
 296 仲間に相談
 649 ひらめき共有