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
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
12 commentaires

Here is the formula for Late: 

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

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

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
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

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
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

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

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Thanks! I stumbled on this post looking for something else, but that's actually pretty useful Ashley Fischer

Btw, is this Webinar by Mobeen Tahir available somewhere? Or something similar?

I would love to learn more advanced Wrike Analyze usage :)

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hi Sébastien Faucon, welcome to the Community 🙂 

I'm checking this out for now and will be back to you ASAP! 

 

Elaine Community Team at Wrike Wrike Product Manager En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online

Elaine Wrike Team member En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hi Sébastien Faucon, you should have received this now. Shout if you need anything else 🙂 

Elaine Community Team at Wrike Wrike Product Manager En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online

Elaine Wrike Team member En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hi Elaine, would it be possible to get access to the webinar as well?

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hi Jochen Deile, that's with you now. 

Let me know if you need anything else 🙂 

Elaine Community Team at Wrike Wrike Product Manager En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online

Elaine Wrike Team member En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hi Elaine, I'm also interested in viewing the webinar. Could you please share?

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

@Elaine, I would like to see this Webinar as well please!

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

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

Haut de la page
Didn’t find what you were looking for? Write new post