Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Is it possible to colour the expression based on the value of dimensions?
for eg:, my table has Dimension Field1 : Red, Green, Orange
Expression : count(expression)
i need to give different colurs to the expression value.
if Field1 ='Red', whitecolour for expression, if Field1= 'Orange', blue colour for expression.
is it possible? if so, can someone please help with expression?
So changes based on selection in Field1?
May be this?
Count({<Field1>}callsanswered)
Color will change like this:
Pick(Match(Only({<Field1>}Field1), 'Red', 'Orange', 'Green'), White(), Blue(), Green())
I think you sure can...May be like this
Pick(Match(Field1, 'Red', 'Orange', 'Green'), White(), Blue(), Green())
What do you mean the dimension colors here
no sunny its not working
Anil,
i want to give colours to expressions not dimensions
Can you show your table how it looks?
sunny, picture attached
I don't seen any issues
Its working sunny.
one more thing, if i select the any value in the 'Field1' in a list box, the value of my expression shouldnt change in this table.
my expression is count(callsanswered). if any calendar selection is made, then it should reflect the change.
can you please help?
So changes based on selection in Field1?
May be this?
Count({<Field1>}callsanswered)
Color will change like this:
Pick(Match(Only({<Field1>}Field1), 'Red', 'Orange', 'Green'), White(), Blue(), Green())