I have a dashboard that contains a chart that I want to show data for multiple locations. When I select 'split by' and pick the location id field, there is no option to show by color - all are gray. I think this is because there are too many values, but I don't mind if the same colors are recycled. Is there any way around this limit?
This is information for 2 locations:
Thank you
Randy McGregor
Hi Randy,
If you go to the Series tab and scroll down you can see where the colors are defined. It looks like it defines a color for the first 25 values or so, and then applies the "other" grey color. What happens if you click "Add Series" and enter one of the location IDs that's been included in the "other" category?
Jill
Thanks Jillian,
I don't even get that far. No unique colors are created. I selected '+ series' doesn't have any effect, nor does, 'Load series.' I think over a certain number of unique values, it just throws in the towel. Users will only select at most 3 or 4 unique values, so all I need is a way to distinguish them. I don't expect to make 1,000+ colors distinguishable. I've hit this wall before and it's a stumper.
Okay, I got this to work but it's really finicky -
If I choose the Split By field first, then the Category, then the Statistic, I get the grey symbology.
If I fill out the drop downs in a different order - Category, Split By and then Statistic, I get the correct symbology.
This of course should not matter but does that work for you?
I really appreciate it, but alas, that didn't do it. I tried both orders and gray both times. I can change the color and I've done that. (Gray is just so boring) I am trying to allow the user to compare multiple locations and I have over 1,000 locations. I think I've hit a wall. I'm going to see if I can label the lines.