9 Replies Latest reply: Jan 27, 2016 6:02 PM by Shyam BV RSS

    How to Group Values within a Field and show on Bar Chart



      I have a chart with two dimensions ("Region", "Case Type") and one expression ("Hours"). My chart currently looks like below:


      FSR Duration ScreenShot.PNG


      The numbers on the Y-axis denote the "Hours". X-axis has the "Region" values and different "Case Type"s are stacked for each region (each case type colored differently).


      I'd like to know if I can put a number of these "case type"s into different groups. Do you have any suggestions on how to achieve this?


      To give an example - Let's say "Case Type" dimension has a total of 5 values: AB, CD, EF, GH, IK. What I'd like to do is group these different fields - like 'AB' and 'CD' become 'Field_1', 'EF' and 'GH' become 'Field_2', and 'IK' stays as 'IK'. In the end, I'd like to show these grouped values ('Field_1', 'Field_2' and 'IK') stacked for each region (3 colors instead of 5 colors for each region).


      I can't use grouping, since grouping works for different fields and I'm trying to group different values for a field.



      Thanks in advance,