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!
You could try making the other 2 different shades of grey. That way the red one will pop.
Hi Ashleigh,
One option to manipulate things is to use "bucketing" and filter a value for each performance. Then you have more control over the order as you can rearrange the values. It takes a little more time than just using a break by, but it does allow you to put them in any desired order.
Happy analyzing!Christine
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.