Hi,

I have a following conundrum that I'm trying to resolve.

In studio analysis I have a tab in which I have two Button dropdowns.

First one is for selecting a categories like company code, business unit, country etc. Based on selection from the first dropdown users can select specific company codes or BUs etc. in the second one (this drop down is a multiple choice one). That selection is stored in a variable which feeds the bar charts. So for example someone is selecting 4 company codes and my chart shows bars for each company code selected for each month.

In a basic form all bars are the same color. I would like to color it the way that each selection from second dropdown (i.e each cmpany code) has its own color. I cannot use series palette as user can select from 1 to n number of company codes (or BUs or countries etc.) so the number of colors needs to be automatically adjustable.

The original idea was as following - lets create 5 to 10 variables and each would take one value from the variable storing selections from the second dropdown. And later we would assign those new variables to colors in Series color mapping.

The variable which would be split, although it is set as text/replacement seems to be holding those selections in something resembling python's list of strings, and it seems that it is impossible to select element of that list and use it somewhere else like I would do it in python.

Does anyone has idea either how to rework the original idea or maybe how to do it some other way?

Thanks,

Karol