Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
I have a line chart with month and Function(Having 4 different values) as Dimensions, One expression
So i have a line chart with four lines (Since having Four Functions(Dimension))
I have given colors according to Function in background color of the xpression, Initially the lines were displaying according to Functions colors which i have given in background color
Pick(WildMatch(Function,'XXXX','YYYY','ZZZZ','AAAA'),RGB(141,170,203),RGB(179,179,179),RGB(233,118,0),RGB(10,10,150))
But when i select month, the colors of the line were changing, How to restrict it
thanks in advance
May be this
Pick(WildMatch(Only({<Month>}Function),'XXXX','YYYY','ZZZZ','AAAA'),RGB(141,170,203),RGB(179,179,179),RGB(233,118,0),RGB(10,10,150))
I think i need to bypass the Month dimension in Pick expression
Pick(WildMatch(Function,'XXXX','YYYY','ZZZZ','AAAA'),RGB(141,170,203),RGB(179,179,179),RGB(233,118,0),RGB(10,10,150))
I know to bypass in Set analysis, but how to do in pick expression
May be this
Pick(WildMatch(Only({<Month>}Function),'XXXX','YYYY','ZZZZ','AAAA'),RGB(141,170,203),RGB(179,179,179),RGB(233,118,0),RGB(10,10,150))
Hi Sunny,
Superb bro, it solved.
Can you explain how the expression works
Thanks
Function is the field where you needed to ignore selection. So, in order to use set analysis, I used Only() function around it...
I need to ignore Month selection
Only({<Month>}Function)
in the above expression we are ignoring month and considering function right,
please correct me if i am wrong
We are ignoring selection in Month field for the field function is how I would put it
OK Thanks