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 🙂

1
4 commenti
Spot On Innovative Approach Stellar Advice

Here is the formula for Late: 

I didn't get a screen capture of on time.

1
Azioni per commenti Permalink
Spot On Innovative Approach Stellar Advice

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.

0
Azioni per commenti Permalink
Spot On Innovative Approach Stellar Advice

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:

0
Azioni per commenti Permalink
Spot On Innovative Approach Stellar Advice

Ashley Fischer Thanks so much. This got me off to a good start.

0
Azioni per commenti Permalink

Folllowing List for Post: Analyze Widget - Tasks Completed on Time vs Late
[this list is visible for admins and agents only]

Su
Didn’t find what you were looking for? Write new post