Analyze Widget - Tasks Completed on Time vs Late
This is a follow up to the Wrike Webinar: Most Common Use Cases of Wrike Analyze that was hosted today by Mobeen Tahir.
Mobeen showed a function for how to get a pie chart that showed tasks completed on time vs late and I'm hoping someone can share it here.
Thanks in advance 🙂
Here is the formula for Late:
I didn't get a screen capture of on time.
Thanks Ashley Fischer
Adding the >0 produced a syntax error. I'm new to Analytics boards and after attempting this, having step by step from start to finish for the new widget might be the most helpful. I have a feeling I did something wrong with categories or values someplace else.
Jessie Stith
I played around this morning and found that all I had to do was reverse the order of the fields in the DDIFF portion of the formula:
SUM([Task ID], if (SUM(ddiff([Days in Task Completion Date], [Days in Task Due Date]))<01,1,0))
I viewed the data in a pivot table first to confirm the formulas were accurate:
From there I was able to change the graph type to Pie Chart:
Ashley Fischer Thanks so much. This got me off to a good start.