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