Calculate average age till Last month, Last week, last year.
I am need to compare the average age for the current month and previous month . Now, the card that I am using to show this is comparative gauge which will display if the metric is trending up or down. So, I tried to calculate the average age for previous month in beast mode but did not work. Can anyone please help me with the formulas?
Thanks in advance
Since comparative gauges only read the first row in a dataset, I have found building a magic ETL dataflow to calculate the previous value and put it in the same row as the current value, the best way to power the comparative gauge.
You can calculate the previous value by using the rank and window tile in the ETL.
Here is a link to the KB article for Rank and Window:
And here is the KB article for Comparative Gauges:
https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Comparative_Gauge**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
It's unclear whether you need help building a card or writing a beast mode.
what didn't work about calculating the previous month?
how is your data currently structured?
can you get the correct results in a table card?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"0
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 474 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 214 Visualize
- 259 Beast Mode
- 2.1K Charting
- 12 Variables
- 85 Cards, Dashboards, Stories
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 190 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive