1 Reply Latest reply on Nov 13, 2018 4:53 AM by Zhouyi Zhang

    Grouped data not displaying the corresponding rows

    Dani Baskaran

      Hello Everyone,

       

      As you could see in my workbook, I have a data set that has peoples' age and their favourite genre. I'm trying to group users with range corresponding to their age. I have achieved the correct results.

      But, as you could see in the below pic, in the age group [36-45], there are only 2 users who have 'Action' as their favourite genre. But when I click the 'View Data' option, it displays 3 rows.

       

       

       

      Even though I have obtained the correct result from the chart, when I use this particular chart for dashboard, it messes things up.

       

      Is there any other way to do this?

       

      - Dani