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 🙂

Find more posts tagged with

Comments

Ashley Fischer

Here is the formula for Late:

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

Jessie Stith

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.

Ashley Fischer

@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:

Jessie Stith

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

Sébastien Faucon

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

Elaine McDonagh

Hi @Sébastien Faucon, welcome to the Community 🙂

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

Elaine McDonagh

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

Jochen Deile

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

Elaine McDonagh

Hi @Jochen Deile, that's with you now.

Let me know if you need anything else 🙂

Brian Hunt

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

Cody Weber

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

Elaine McDonagh

Hi @Brian Hunt, @Cody Weber, that's with you both now 👍

Lauren Day

@Elaine McDonagh Would I be able to get access to this webinar as well?

Elaine McDonagh

Hi @Lauren Day, no problem! Sorry for the delay, that's with you now 👍

Abby Golebiowski

@Elaine McDonagh I would also like to get access to this webinar, please!

Elaine McDonagh

Hi @Abby Golebiowski, apologies for the delay. That's with you now 🙂

Gary Fallon

Hi @Elaine McDonagh, I would like to watch this webinar. Could you please share?

Elaine McDonagh

Sorry for the delay @Gary Fallon, with you now 👍

Vang Her

@Elaine McDonagh,

Sorry to resurrect an old thread, but could I get a link to the webinar also? Thank you.

Tuomo Suominen

Thanks for bringing this up @Vang Her - I would also be interested in a link to the webinar!

Basudha Sakshyarika

Hi @Vang Her and @Tuomo Suominen 🙋🏻‍♀️ Sorry for the delay here—I’ve shared it with both of you now!😊

Gabriel Enrique Hernandez

@Elaine McDonagh can I have access to that webinar too? please.

Sam Khemani

Can we create this metric on the Enterprise account through Dashboards?