Conditional Palette in charts

[peter.almstrom]

Hi.

I have a graph, as the attached picture, where I'm using a conditional palette. My problem is that I want only the blue columns to be affected by the conditional palette not everything. The problem is that the string variable is a report calculation and I cant use any on the build in functions.

Any tips on how to solve this would be greatly appreciated!

/Peter

[PRIT AMRIT]

Hi,

If i have understood your question, then you can capture the value for your blue line and apply the conditional pallet on that?

Say, you have four countries 'US', 'UK', 'IND', 'RUSS' in the X-axis and showing Blue, Green, Yellow, Black colors respectively.

You want 'Blue' color to change conditionally?

Then you can just create a boolean variable Country='US'
Then apply the conditional pallet, if yes, then Color='RED'

Is that ok?

Thank
p

[peter.almstrom]

Hi
The datasource is a transformer cube so its not as easy. The blue line consists of tuples like this:
Blue line - tuple([A],,[Actual])
Green line - Tuple ([A],,[Budget])
Yellow line - tuple([A],,[Forecast])

And I have months in my x-axis.

I want the blue line (only the blue line) to change color when the currentmember([hierarchy]) is larger than a specific month.

Hope this explains this a bit further.
/Peter

[PRIT AMRIT]

Hmmm...

To display Blue, Green, Yellow have you created a string variable i.e.

tuple([A],,[Actual]) -- Blue
tuple ([A],,[Budget]) -- Green
tuple([A],,[Forecast]) -- Yellow

Can you add one more condition like

tuple([A],,[Actual]) and currentmember([hierarchy]) is larger than a specific month -- Red

Just a guess...