Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Goodmorning everyone
I made a dash with three objects of type object where calculating the sum of the budgets of all customers of the agent A, agent B and C Agent
to make the sum in the three use the box setAnalysis.
num = (sum ({$ <[Agent] = {'A'}>} [Budget] / 1000000), '### 0,0')
num = (sum ({$ <[Agent] = {'D'}>} [Budget] / 1000000), '### 0,0')
num = (sum ({$ <[Agent] = {'C'}>} [Budget] / 1000000), '### 0,0')
I also have a histogram graph type where you do the analysis for applying the agent also filter text objects take the filter and then displays only the value associated with the selection.
I would rather that regardless of the solution BOX visualizzassero text data.
It is possible via SET Analysis disregard the current selections?
Thanks for collaboration
Andrea
Not sure what you exactely want.
If you want to disregard the current selection, you can use set identifier 1:
sum ({1 <[Agent] = {'A'}>} [Budget] / 1000000)
Or if you want to regard the user selection in Agent, use the intersection set operator *:
sum ({$ <[Agent] *= {'A'}>} [Budget] / 1000000)
Not sure what you exactely want.
If you want to disregard the current selection, you can use set identifier 1:
sum ({1 <[Agent] = {'A'}>} [Budget] / 1000000)
Or if you want to regard the user selection in Agent, use the intersection set operator *:
sum ({$ <[Agent] *= {'A'}>} [Budget] / 1000000)
It is exactly what I wanted through 1000
really nice