limit the dimension

[adiarnon]

hi,

i have this table:

call num	handler name	days
1	adi	4
2	shai	23
3	adi	1
4	tal	2

i want a bar chart that in the dimension i will have the call num and in the expression the days.

but i want that only the calls num (dimension) of adi will shown (1,3) .

how can i do that?

[rustyfishbones]

Add the Set Analysis in the Expression like below

[rustyfishbones]

You can also do this as a calculated dimension like this

but make sure you suppress 0 values like below

[Colin-Albert]

Rather than hard-coding the restriction, why not add a list box to allow the user to select the handler name?

[adiarnon]

tnx,

but i still see all the call nums in the y axe.

[rustyfishbones]

I get this, Is that what you need

[adiarnon]

but if i want that even if i am filtering by other handler i will still see the chart with the data of adi calls?

[adiarnon]

because i need a chart of each handler....

[rustyfishbones]

See attached

[#10]

Hi Arnon,

Please try this,

Sum({$<Handler={$(=Handler)}>}Days)