Serial chart - split by gives up when too many unique values?

Question

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

RandyMcGregor3 · Answer

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.

JillianStanford · Answer

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?

RandyMcGregor3 · Answer

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.