If you'd like to keep the alternate, smaller results, but just not label them, you can create a calculated field that only returns results based on the RANK() of the item in the pie.
RankExample.twbx 1.2 MB
1 of 1 people found this helpful
Welcome to the Community!
1. Pie charts are great if you only have a few values, but with so many slices even if you labeled the top 5 ONLY it is still difficult to tell the proportions of each slice. Consider using a Bar Chart instead.
2. You can label the Top 5 by following these directions
a. Create a calculated field (Analysis>Create Calculated Field)
b. Enter the formula RANK(SUM([Connected Assets]))
c. Drag the calculation to the Label Shelf
d. Right-Click on the field and Select Compute Using>Module Type
3. These directions should work for most viz types.
Hope this helps!
OH HA! I forgot the Label part! Derrick's directions are better!
It's still better as a bar!
Thank you very much!
I do have a couple of more quick questions.
1. I am not sure how to mark your answer as correct, could you explain this to me?
2. With your help, the labels are now on the pie chart as seen below but I cannot format them in anyway. I plan to put this on a dashboard but when I do you cannot tell which label is to what slice, any advice?
The formatting options for labels are available when you click the "label" button in the "Marks" card.
You will probably still have some issues, because of a lack of space - but you might place around with the alignment, etc. to see if you can get something that looks decent. Using the color legend on your dashboard is another solution that might work.
You should be able to mark an answer correct with a button underneath my answer, like this: