How to write expression to get count of ID's

[#1]

Hi,

I have three columns Queue,FromQueue,ToQueue. All the three columns contains same data. I need to generate a chart by using three columns i,e I need to get count of ID's as how many ID's are in and how many ID's are out based on Queue.so that it will appear like below.Could anyone help me how to write condition in Expressions tab

Queue	In	Out
work	4	32
process	34	5
aggreement	5	6
solution	0	0

Thanks.

[#2]

aggr(count(In),Queue)

aggr(count(out),Queue)

[#3]

Did you put Queue in your Dimension?

If yes, then create two expressions using Set Analysis:

In: count(distinct {<Field={'In'}>} ID)

Out: count(distinct {<Field={'Out'}>} ID)

where Field is the field which allows you to see if an ID is in/out.

Hope this makes sense!

[#4]

Hi,

Thanks for this. but somehow I am not getting correct results when I am trying by date wise as I have same data in Queue,In,Out.Could you help me as I am reaaly struggling this since four days.

[#5]

Hi,

Thanks

Now I am getting new problem.

How to write expression in dimension so that I need to see Under Queue only like below as I have so many names .but I need only four. If I get this may be my problem would solve. please help

Queue
work
process
aggreement
solution

[#6]

IN DIMENSION TAB--

CLIK ON ADD CALCULATED DIMENSION

     then here write your expression in dimension

************************

or in dimension tab add field Queue then clik on edit button then here write your expression.

[#7]

Hi,

How to write the condition in expression tab? could you tell me