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
Folllowing List for Post: Pie Chart Widget Help
[this list is visible for admins and agents only]
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:
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!
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.