Max Slice before 'Other' Pie Chart but applies to Line Chart?

verytiredgirl
verytiredgirl Member
in Cards, Dashboards, Stories

So I have a field called 'title' and there's like 100 unique value in there. When using the pie chart I just want to see top 7 slices/title that has the highest Pie Value.

image.png

Is it possible to do the same with line chart where X= date, Y = pie value, Series = title (but only showing top 7 titles that has most Pie Value?).

Tagged:

Answers

  • ggenovese
    ggenovese Contributor

    If you add a RANK() beast mode then you can filter your card on RANK < = 7

    RANK() OVER (PARTITION BY `date` ORDER BY `pie value` DESC)

Categories