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.
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 :)
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
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
Hi Elaine, would it be possible to get access to the webinar as well?
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
Hi Elaine, I'm also interested in viewing the webinar. Could you please share?
@Elaine, I would like to see this Webinar as well please!
Hi Brian Hunt, Cody Weber, that's with you both now 👍
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
Elaine Would I be able to get access to this webinar as well?
Hi Lauren Day, no problem! Sorry for the delay, that's with you now 👍
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
Elaine I would also like to get access to this webinar, please!
Hi Abby Golebiowski, apologies for the delay. That's with you now 🙂
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
Hi Elaine, I would like to watch this webinar. Could you please share?
Sorry for the delay Gary Fallon, with you now 👍
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