Color Expression when expression is set analysis

[supriyabiware]

Hello All,

My Chart expression is as below

=Count({1<YearMonth = {"$(=$(vPreviousYearMonth))"},
DEPARTMENT                          = $:: DEPARTMENT,
SUBDEPARTMENT                 = $::SUBDEPARTMENT,
ASSIGNMENT_GROUP         = $::ASSIGNMENT_GROUP,
PRODUCT_TEAM_SC            = $::PRODUCT_TEAM_SC,
AREA                                            = $::AREA>}distinct INCIDENT_ID)

And my color expression is 

=if(SERVICE='Advanced Support', $(ColorA1),if(SERVICE='Support',$(ColorA2),if(SERVICE='Others',$(ColorOthers))))

But still somehow when i drill down on chart it doesnt give proper colors at lower level .

Any help??

Regards,

Supriya.

[agigliotti]

what about your chart dimension?

[supriyabiware]

Hi,

Dimension is cyclic dimension (Dept, sub Dept, Assigned Group)

[agigliotti]

could you post the qvw to look in ? otherwise I can't help you find out why.

[supriyabiware]

here goes. i need consistent colors even after selecting any dimensions or filters

[supriyabiware]

if i remove 'One color gradient' option from each color. seems to be working ok.

not sure why the formula mixes all the colors when 'one color gradient' is on.

[jochem_zw]

You Have to add your set analysis from the expression to the background color expression. The current active VW_Service is based on your selection for year etc. 

[Brett_Bleess]

Did the last post get you what you needed?  If so, do not forget to return to the thread and use the Accept as Solution button on his post to give him credit for the assistance and let other Members know that worked.  If you did something different, please consider posting that and then mark it as the solution, and if you still need further help, leave an update for us.

Regards,
Brett