Hi,
I have not been able to create a pie chart I would like to see, although this relates to all chart types.
On a dashboard, I want to show a metric with 2 values, which is a calculated value from the content of a single text field:
1. A count of how many records in the last month that have an empty value for that field
2. A count of how many records in the last month that have any value.
I should therefore expect to see a pie chart with two values for these two calculated totals. Instead the best I can get is a total of the empty values and an entry for each and every record that has a value i.e. not a count on this number.
I have tried, adding a second series and different objects other than 'Case', which is where this text field resides.
Anyone know if and how this is possible?
thanks
Mark
Like
Dear Mark,
To do that in a pie chart you would need to add a separate column to your Object (e.g. Assignee filled in) and populate in a business process. After that you would be able to group by this this column and get a needed chart. Also you can use Column chart, in this case in would look like that ( http://prntscr.com/o30kqc.). I used Case as your object and assignee as a filled you want to monitor. On the series 1 the setting is the same with an exception that in a filter Assignee field is filled in instead of not filled in.
Best regards,
Dennis