Get Top 1 for each time in full time period

Question & Answer
, , ,
1

Hi
I want to show top 5 downloaded for each month but when I do filter top 5 by count distinct, I shows top 5 in total time period which is top 5 downloads from Jan 2023 to Oct 2023.

So for example in the picture each month should have 5 top 5s. Jan has ABCDE Feb ABCFG something like this.

image
image942Ă—928 67.3 KB

2

Hello @qsqqs !

Does this visual need to be a line chart? You could achieve this using a visual like a stacked bar chart:

image
image1068Ă—502 73.1 KB

image

To achieve this you will need to make sure to press the “don’t show other” option in the visual edit menu at the top right of the visualization
image

Let me know if this helps!

1 Like
3

Hi @duncan,
yes I’d prefer the line chart since I also want to trend.
Thank you!

4

image
image263Ă—665 25.4 KB

@qsqqs In addition to filtering Top N, you also need to group on the field based on which you need the Top N as shown in the screen shot here( ORDER DATE). Here is the documentation for your reference:

I hope this feature helps with your requirement.

1 Like