Analyze Widget - Tasks Completed on Time vs Late

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 Become a Wrike expert with Wrike Discover

Elaine Wrike Team member Become a Wrike expert with Wrike Discover

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

Elaine Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Elaine Wrike Team member Become a Wrike expert with Wrike Discover

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 Become a Wrike expert with Wrike Discover

Elaine Wrike Team member Become a Wrike expert with Wrike Discover

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 Become a Wrike expert with Wrike Discover

Elaine Wrike Team member Become a Wrike expert with Wrike Discover

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 Become a Wrike expert with Wrike Discover

Elaine Wrike Team member Become a Wrike expert with Wrike Discover

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 Become a Wrike expert with Wrike Discover

Elaine Wrike Team member Become a Wrike expert with Wrike Discover

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 Become a Wrike expert with Wrike Discover

Elaine Wrike Team member Become a Wrike expert with Wrike Discover