Chart does not group similar values
I have a calculated field called 'Status' which results in either 'Marked', 'Partially Marked' or 'Unmarked'.
This field was previously a text field.
I had a chart set up that displayed a Pie chart which grouped all similar statuses together to display the total number of 'marked', 'partially marked' and 'ummarked' records. That is, the pie chart showed three separate slices.
Now, however, that the field is a calculated field, the pie diagram separates every instance of the status into a separate slice...ie, the number of slices equates to the number of records in the table. Similar values are no longer grouped together.
Can anybody help?