Forum Discussion
cumulative target line
We have a metric for employees to complete 5 of a specific report type every year. I need to create a line for target number of reports throughout the year, but need it to be cumulative, so th...
I did try that cumulative formula. It's also giving me variable small numbers for each day, with some rows blank. And the numbers don't make sense for the data it's supposed be calculating.
MFelix
Super User
Super UserWhat is suppose to be the value oer day?
You refer you have 5 reports per year making this a daily measure and as you refer 5/365 = 0,013.
In my opinion this is not the best way to show the target for this type of information.
Considering only 1 person the target for the full year is 5 doesn't matter of he is on January 1 of December 31st because making the split of reporting troughout the year seems odd to me.
Can you elaborate more on what you want to compare and follow up?
Regards,
MFelix
You refer you have 5 reports per year making this a daily measure and as you refer 5/365 = 0,013.
In my opinion this is not the best way to show the target for this type of information.
Considering only 1 person the target for the full year is 5 doesn't matter of he is on January 1 of December 31st because making the split of reporting troughout the year seems odd to me.
Can you elaborate more on what you want to compare and follow up?
Regards,
MFelix