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 Узнайте о самых популярных функциях Wrike и советах по его использованию
Elaine Wrike Team member Узнайте о самых популярных функциях Wrike и советах по его использованию
Hi Sébastien Faucon, you should have received this now. Shout if you need anything else 🙂
Elaine Community Team at Wrike Wrike Product Manager Узнайте о самых популярных функциях Wrike и советах по его использованию
Elaine Wrike Team member Узнайте о самых популярных функциях Wrike и советах по его использованию
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 Узнайте о самых популярных функциях Wrike и советах по его использованию
Elaine Wrike Team member Узнайте о самых популярных функциях Wrike и советах по его использованию
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 Узнайте о самых популярных функциях Wrike и советах по его использованию
Elaine Wrike Team member Узнайте о самых популярных функциях Wrike и советах по его использованию
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 Узнайте о самых популярных функциях Wrike и советах по его использованию
Elaine Wrike Team member Узнайте о самых популярных функциях Wrike и советах по его использованию
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 Узнайте о самых популярных функциях Wrike и советах по его использованию
Elaine Wrike Team member Узнайте о самых популярных функциях Wrike и советах по его использованию
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 Узнайте о самых популярных функциях Wrike и советах по его использованию
Elaine Wrike Team member Узнайте о самых популярных функциях Wrike и советах по его использованию