Pie Chart Widget Help

I'd like to build a custom pie chart that shows a breakdown of current tasks that are overdue, due this week, and future. Or something like that. Struggling with that build. Any help would be appreciated!

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
2 comentários

Hi Eric,

Great question! This is an example of a time when you'd have to use multiple values as a custom grouping. For this pie chart, you'll put nothing in the Categories area, and instead write three formulas to count those tasks.

The first value (Count of Overdue Tasks) would be something like this:

( COUNT( [Task ID]), [Task Due Date], [Task Status Group] )

Where the Task Due Date would be filtered for a Time Frame in the Last 360 Days, and Task Status Group is Active.

Then, duplicate your value (or create a new one) for each of the other pie slices you'd like to display, updating the formula to filter for the tasks you are interested in.

I hope that helps!

Mark Tapia Community Team at Wrike Wrike Product Manager Aprenda sobre as funcionalidades e melhores práticas em Wrike com o nosso Treinamento Webinar Online

Mark Tapia Wrike Team member Aprenda sobre as funcionalidades e melhores práticas em Wrike com o nosso Treinamento Webinar Online

2
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Thanks Mark! That seems to be it! I wish there were a Task Overdue option. In this instance that is only one layer to it but in other instances I had figured out how to build some formulas to figure that our for tables.

2
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Pie Chart Widget Help
[this list is visible for admins and agents only]

Alto
Didn’t find what you were looking for? Write new post