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 Conosci le straordinarie funzionalità di Wrike e le best practices

Elaine Wrike Team member Conosci le straordinarie funzionalità di Wrike e le best practices

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

Elaine Community Team at Wrike Wrike Product Manager Conosci le straordinarie funzionalità di Wrike e le best practices

Elaine Wrike Team member Conosci le straordinarie funzionalità di Wrike e le best practices

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 Conosci le straordinarie funzionalità di Wrike e le best practices

Elaine Wrike Team member Conosci le straordinarie funzionalità di Wrike e le best practices

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 Conosci le straordinarie funzionalità di Wrike e le best practices

Elaine Wrike Team member Conosci le straordinarie funzionalità di Wrike e le best practices