Past Due Tasks in Ranges
I'm trying to find a way to calculate the count of tasks that are "aging." In essence are past due but in tiered ranges.
I need to know the number of tasks past due in the following ranges:
- 0-30 days
- 31-60 days
- 61-90 days
- 90+ days
I can calculate the number of tasks that have due days in those overlapping ranges. For example, I can easily calculate the tasks due in the past 30 days. Then, calculate the number past due in the past 60 days. But then I end up with overlapping values, as some of the tasks counted in the "past 30-day" rage are also included in the "past 60-day" rage.
I'm missing something simple, but I can't seem to nail this down.
I'm curious about a solution for this as well. I ran into a similar problem when trying to color code custom field values, but if it could be solved on an analytics board that would be great.
Hey Brian Gotti! Good to see you in here, it's been a while!
The best way to do this is to set up a widget (most likely a column widget) is to use multiple Values that are filtered to limit the due dates. The formula is a bit intense, but you'll need to combine two IF statements to capture the situation where a task is over X days but under Y days overdue.
For example, for the tasks 31-60 days overdue, you can add some filters:
I hope this at least gets you started!
Mark
Mark Tapia Community Team at Wrike Wrike Product Manager En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online
Mark Tapia Wrike Team member En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online
Hi Mark Tapia!
Good to talk again.
I'm giving this a go here and getting a syntax error in Analyze.
And this is the error that it kicks back to me.
Brian Gotti I believe this is an issue with the output of the DDIFF function. For some reason, we have to put what is called an "aggregator" on it, to turn it from multiple values into a single value. So, in front of your DDIFF function, you'll need to place a MAX function. It will look like this:
Make sure to do this on both DDIFF functions and make sure to close out your MAX function with extra close parentheses after your DDIFF functions.
Mark Tapia Community Team at Wrike Wrike Product Manager En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online
Mark Tapia Wrike Team member En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online
Thanks Mark Tapia!
Got it to work!
Jessie Stith Looks like we got it solved.
I was able to create a few widgets on a report to display the counts this way:
For the last one, I just did > 180 and < 999.
Thank you Brian Gotti and Mark Tapia!! :D