I have a metric with Budgeted Headcount at monthly level. I want to achieve the same metric at yearly level but the headcount at yearly level needs to be the headcount as of the last month of the year and not a summary of all months. Need help with the logic to achieve it.
Solved
Pick last month of the year's data only and display it at yearly level
- Helper
Best answer by Min Li
You can place the metric in a table and set the Month dimension aggregator to Last or Last Non Blank. This ensures that when the Month level is aggregated to Quarter or Year, the value from the last (or last non-blank) month in that period is used for the higher-level aggregation.
+14- Master Helper
- Answer
You can place the metric in a table and set the Month dimension aggregator to Last or Last Non Blank. This ensures that when the Month level is aggregated to Quarter or Year, the value from the last (or last non-blank) month in that period is used for the higher-level aggregation.
+9- Employee
Hi
If you were looking to have the result in a separate metric you could try the following formula:
'Headcount metric' [by lastnonblank: Month.Year]
Otherwise,
Thanks!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.