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...