Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Several lines in table - Pie chart does not count the doubles

Hello community,

 

this is my data, 9 rows.

 

Name, Type, Category

A, S, Green

A, S, Blue

B, XXL, Green

C, S, Yellow

D, S, Red

D, S, Blue

E, M, White

F, S, Magenta

F, S, Blue

 

I want to display types in my pie chart. At the moment I get this numbers of types: 4xS and 1xM and 1xXXL.

My count is ignoring rows of a type in combination with the same name.

"A, S, Green" and "A, S, Blue" is counting for example only once instead of twice.

But I Want to get also the doubles. I want to get 7x S and 1xM and 1x XXL.

I am looking forward to your feedback. Thank you.

 

 

  • Anonymous , do you see any exclamation sign , near to visual? That may be cause of lot of data for visual. if so, Reduce some data and check

3 Replies

  • Anonymous ,Not clear.

     

    You can use Name as legend , Type as details and try

     

    The information you have provided is not making the problem clear to me. Can you please explain with an example.

     


    Appreciate your Kudos.


    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you for your fast reply. Name as legend , Type as details is not working, the chart is white and blank. When I make an exampleFile it´s working fine. But not in my real data. I think about an error in my dataset. 

       

       

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User

        Anonymous , do you see any exclamation sign , near to visual? That may be cause of lot of data for visual. if so, Reduce some data and check