Goal: I have a data set consisting of students and scores as the column in Tableau. I used the Rank_parcentile() to rank them:
Rank_parcentile(sum([score]))
Created the following group:
IF [percentile] > 0.8
THEN "Top 20%"
ELSEIF [percentile] <0.8 and [percentile]>0.5
THEN "Mid 30%"
ELSEIF [percentile]<-0.5 THEN "Bottom 50%"
This worked fine and even grouped them as I wanted but now the problem is that sometimes I have too many students and they can't fit in a single graph reasonably. Is there a way to divide the top 20% in one graph , the mid 30% in second and the bottom 50% in the third graph?