Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please use the attached one.
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())
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())
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.
Is this something you are looking for?
Please use the attached one.
Hi Sudeep,
Yeah, that's a great solution!!!
This will help to fix my issue. Thank you