6 Replies Latest reply on Jul 23, 2012 4:50 PM by philmodjunk

    Chart does not group similar values

    oli@acm.ac.uk

      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