AnsweredAssumed Answered

Chart does not group similar values

Question asked by oli@acm.ac.uk on Jul 23, 2012
Latest reply on Jul 23, 2012 by philmodjunk

Title

Chart does not group similar values

Post

Hi there

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?

Many thanks

Oli

Outcomes