Hi, everyone
I make a line chart which is colored by selected field.There are a lot of lines, and I only want top-20 to be displayed, so the rest goes to ‘other’ group.
For some reason by default QS displays bottom-N lines and groups the rest to ‘other’ while I need to show top-N and group all smaller values to ‘other’.
Couldn’t find any parameters to choose what values (top/bottoms) are going to be displayed separately and which are going to be grouped as ‘other’. Is there any known solution for this?
Hi @dianak
i did a short test myself and its the sort of the color field (here store_id) and not the value of the selected measure (here quantity)
Can you confirm that?
BR
Checked it. Yes, you are right. I misunderstood what this top-bottom thing is about.
So, in my case the top-bottom switch wouldn’t work as I want it to.
Do you know how to show top biggest values? Top-bottom filters?
You mean