I have a viz that shows total sales for each prior year and also the current year to date (eg July 2016 to Aug 2016). The end date for the YTD period is determined by a filter.
I would like to show an annualised sales estimate determined by the number of months of data.
Eg July Sales $50,000
August Sales $100,000
Annualised Sales calculation would be
(($50,000 + $100,000) / 2 )* 12 = $900,000
I'm having difficulty counting the number of months (2 in this case) to create this calculation.
I feel this should be quite easy but have not been able to find this through a search.
Hi John! What if you were to create a calculated field like this:
And put the aggregated average of that into the view? That would give you the correct result, wouldn't it?