Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I'm trying to figure out how is possible to customize the limit for a line chart according to a specific formula;
Here is my problem:
I've built a line chart:
- Group (X axis): Dates (Month+Year)
- Measure (Y axis): Count(Event)
Then I've multiple lines, one for each "Component"
What I need to do, is to limit the number of lines shown to 5; I've tried to do it from the menu, by setting the limitation to the first 5 integer value but the result obtained is not the expected one; In this way for each date the graph return the top 5 "Component" according to the Measure formula... However what I need is to show for all the dates the same 5 "Component" which are defined according a "total" formula...
How can I do it?
Thanks!
If you make your dimension for Component look something like the below, I think it should work. So you would have:
Dimension 1: Date
Dimension 2: =if(aggr(Rank(Count(Event), Component), Component)<=5, Component)
Measure: Count(Event)
If you make your dimension for Component look something like the below, I think it should work. So you would have:
Dimension 1: Date
Dimension 2: =if(aggr(Rank(Count(Event), Component), Component)<=5, Component)
Measure: Count(Event)
Thanks!
It worked perfectly!