Chars Legend Color Issue

[#1]

Hi Team,

I got a problem regarding Charts legend color. The scenario is I have a Combo Chart where Stack Bar show the Sales value company wise and line show the Growth%,I use one dimenssion and multiple expression. In expression I am using the Background color option, the chart is showing the Sales value for month wise for different company through stack bar.

For individual company I am using individual expression. Color for every company is different and retrive this RGB() for every company from different table, the main transanction table is conected with the color table through the Cname(Company Name) field.

In normal scenario it's working fine but the problem is when for a specific company for a first month if data is not present the legend symbol showing the black color while the stack bar showing the exact color for next month onwards where data is available for this company.

I can't use Company as a dimenssion because I have to show the growth through different expression and combo chart not supported multiple dimenssion & multiple expression.

In above image BBB showing black in legend symbol but the color of BBB is blue which show in a bar.

For better understanding I am attaching the application and the data file also.

Please help.

Regards

Anup

[Anonymous · Accepted solution]

Hi Anup,

this is because your Legend colors are calculated based on the respective values for first Tdate

I did a lil tweak as this calculation need not to be referenced with Dimension I have added 3 variables and passed them to the color

so at any given time as variable are calculated irrespective of Tdate we will get colors calculated for all our expressions

check out the attached application hope this helps

mark helpful/correct answer

regards,

Bhagirath S

[#3]

Thanks Bhagirath. It's working fine.

[Anonymous]

your welcome

Cheers...!!!

Bhagirath