Calculate average age till Last month, Last week, last year.

user055758 · February 2020

Hi Team,

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

Regards,

Shenbak V

MarkSnodgrass · February 2020

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:

https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/03ETL_Actions%3A_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