Hi everyone, running into a design issue that's been bugging me in Analytics haha.
I'm making a line chart as a comparative tracker of multiple shows and their income leading up to opening night. I have it broken out by Production Season and it appears the way the lines are stacked on top of one another is alphabetically. Is there anyway to override this?
See in the screenshot below. Cinderella is our current show we want to track, so I've made it this lovely bright red color to stand out, but lines for others shows from previous seasons are layered on top, obscuring the line we want to see most. It appears that the layering order is alphabetical by show name.
Is there a way I can manually rearrange the way the lines are displaying so that the most current/relevant show is on top?
Many thanks in advance!
Christine is correct. When you make each value shown a filtered value, you can control what lines will show up over the other values. Filtered values are just moving the filtering from the Dashboard or Widget level to the Formula level.
Value relying on the Widget or Dashboard filters.
Filtered value on the Formula = “Filtered Values”
Syntax:
(Aggregation , Filter1, Filter2, FilterN)
You can right click and Edit the Filter and then rename it.
The order of the Values determines the order shown in the visualization. Notice that the top value (grey line - listed 1st) shows up behind the other 2. The 3rd value (red line) shows up above the other 2 lines.
This might be an easier way to understand the sorting.