Plot colors based on combinations

[sureshbaabu]

Hello,

I have requirement to plot colors on chart view based on its presence on category.

Data Set:

Group	Country	Category	no_of_players
A	India	Circket	2
A	India	FB	7
A	Aus	FB	2
A	SA	Circket	6
A	Eng
B	India	Circket	5
B	Aus	FB	8
B	SA	FB	1
B	Eng	Circket	5

In the Data set above:

Group A has presence in India on both Cricket and FB - so I wanted to show it presence in Green

Group A has presence in AUS only on FB - so I wanted to show it presence in Yellow

Group A has presence in SA only on Cricket - so I wanted to show it presence in Blue

Group A dosnt have any data for ENG - so I wanted to show  it as RED

I have attached the expected output for more clarity on the requirement .

Please share your thoughts on the request above.

Thanks,

Suresh

[#2]

You need to put in a background colour in the expression.

Expand out and place the IF statement within the background - you will need to use RBG(0,0,0) etc to get the colour to display.

IF(count{<Group={'A'},Country={'India'},Category={'Cricket','FB'}>}Group)>=1,Green())

[#3]

You need to put in a background colour in the expression.

Expand out and place the IF statement within the background - you will need to use RBG(0,0,0) etc to get the colour to display.

IF(count{<Group={'A'},Country={'India'},Category={'Cricket','FB'}>}Group)>=1,Green())

[whiteline]

Hi.

It's easy. You colors is connected with data with complex key Country|Category.

Create this field in your fact table and load corresponding table with colors.

[sudeepkm]

Is this something you are looking for?

[sudeepkm · Accepted solution]

Please use the attached one.

[sureshbaabu]

Hi Sudeep,

Yeah, that's a great solution!!!

This will help to fix my issue. Thank you