-
Re: Finding "first" values for line chart with cumulative percentage
Sunny Talwar Sep 6, 2017 11:14 AM (in response to Wayne Antinore)Wayne Antinore wrote:
For example in the data below, I know for the week of 7/30 that after 1 day the tasks were 33.33% complete, after 2 days 66.66% complete, after 4 days 83.33% complete and after 5 days 100% complete.
How do you know this? Is this for a specific Task ID or all Task IDs?
-
Re: Finding "first" values for line chart with cumulative percentage
Wayne Antinore Sep 6, 2017 11:19 AM (in response to Sunny Talwar )Hi Sunny, thanks for the reply. This is for all Task ID in the same week. For the week of 7/30/2017 there were 6 tasks, 2 of them took 1 day to complete so that would be 33.33%
-
Re: Finding "first" values for line chart with cumulative percentage
Sunny Talwar Sep 6, 2017 11:31 AM (in response to Wayne Antinore)Something like this?
50% Complete
=Min(Aggr(If(RowNo() >= Round(Count(DISTINCT TOTAL <[Week Starting]> [Task ID]) *0.50), [Days to Complete]), [Week Starting], [Task ID]))
80% Complete
=Min(Aggr(If(RowNo() >= Round(Count(DISTINCT TOTAL <[Week Starting]> [Task ID]) *0.80), [Days to Complete]), [Week Starting], [Task ID]))
100% Complete
=Min(Aggr(If(RowNo() >= Round(Count(DISTINCT TOTAL <[Week Starting]> [Task ID])), [Days to Complete]), [Week Starting], [Task ID]))
-
273660.qvw 154.8 K
-
Re: Finding "first" values for line chart with cumulative percentage
Wayne Antinore Sep 6, 2017 2:44 PM (in response to Sunny Talwar )Hi Sunny,
That's it! Thank you very much. I had to work out the sorting so it worked correctly with the AGGR function. Thanks again!
Wayne
-
-
-