Calculating Compound Annual Growth Rate
Hi, I am attempting to use beast mode to calculate the compound annual growth rate of HH AA% and P2+ AA% between the lowest and highest season year identifiers. Any ideas of how to do this? In a typical compound annual growth rate calculation we would utilize the values for both the most current
period and the furthest one. But in Domo is there a way for get it to still do this calculation, even if we were to change the periods within a filter?
Thanks!
Answers

I'm struggling to understand what you are expecting to calculate. Is the desired calculation (from the screenshot above) to find the value of the change from 4031 to 4039? So for HH AA% you would want to see 1.521.92 or "0.40%"? and for P2+AA% .75.97 or ".22%"?
In that case, you may want to think about utilizing a flex table instead as you can set the change calculation to look at the first value minus the last value and it will respond to filters that get applied. The flex table and also show percent change if that is what you want.
“There is a superhero in all of us, we just need the courage to put on the cape.” Superman0
Categories
 All Categories
 1.7K Product Ideas
 1.7K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 292 Workbench
 4 Cloud Amplifier
 8 Federated
 2.8K Transform
 95 SQL DataFlows
 602 Datasets
 2.1K Magic ETL
 3.7K Visualize
 2.4K Charting
 697 Beast Mode
 43 App Studio
 39 Variables
 658 Automate
 170 Apps
 441 APIs & Domo Developer
 42 Workflows
 5 DomoAI
 32 Predict
 12 Jupyter Workspaces
 20 R & Python Tiles
 386 Distribute
 111 Domo Everywhere
 269 Scheduled Reports
 6 Software Integrations
 113 Manage
 110 Governance & Security
 8 Domo University
 30 Product Releases
 Community Forums
 39 Getting Started
 29 Community Member Introductions
 98 Community Announcements
 Domo Community Gallery
 4.8K Archive