Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys, I am making a dashboard where i have 2 filters for Team and Month. Now i have a bar chart where i am showing some numbers of all teams for every month. In my bar chart dimension is Month and I want to show values for all months for a team selected in a filter disregarding the selection made in Month filter. Can anyone please help me out here..?? i have attached screenshot also.
Regards
Sagar
Hi,
just ignore month field selection from your expression.
example let say,
bar chart expression
sum( {$<Month=>}Sales) // Month= is used to ignore field selection from this expression
and also i u wish to ignore multiple field then simply add multiple value like below
sum ( {$<YEAR = , MONTH = >} Sales)
additional note: in feature if u wish to ignore all field selection from this chart object u can simply use
sum ( {1} Sales)
P.S: refer to the attachment for basic set analysis and syntax usage.
hope this helps to u
Thanks
Deva
For this, you can by-pass the Month field in your expression..
for eg
Sum({$<Month=>}Sales).. Here you have bypassed the Month field, now ur month selection will not impact bar chart
Thanks guys for replying..!! My expression is '($(Pro_T)+$(Qct))/$(Avt)', so i made a variable and now use expression as =sum({}$(New_prod)) Now the problem is i want to show all months data for a particular team but nothing is getting displayed in chart. I am not sure about using sum function..!! Can you please provide solution..?
What exactly are these? Fields or Variable?
($(Pro_T)+$(Qct))/$(Avt)
If these are variables with expressions in them, you might need to ignore selection in the variable definition itself to ignore selection in Month field...