Forum Discussion
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
- amitchandak
Super User
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.- AnonymousNot 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
Super 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