AnsweredAssumed Answered

Chart does not group similar values

Question asked by on Jul 23, 2012
Latest reply on Jul 23, 2012 by philmodjunk


Chart does not group similar values


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, 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