No display data problem

[#1]

Hi all

i have a problem in expression...i have a table named "A".

in that i have a monthly record.. 3 column one of them is flag and one of them is customer id and month code...

i want to have chart with month dim and in that show count of customer that the flag for them is 0 in current month and 1 in previous month...

i really want the answer ...

please help me in this situation...

Regards.

sahar

[tresesco]

Try expressions like:

=Count( Distinct If( Flag=0, [Customer ID]))    // For Current month

=Count( Distinct If( Flag=1, [Customer ID]))    // For Previous month

Or, using set, like:

=Count( {<Flag={1}>} distinct [Customer ID])

=Count( {<Flag={0}>} distinct [Customer ID])

In the dimension Month field.

[sibin_jacob]

HI Sahar,

Please find the attached document.

I used the below expressions to get the count

Count({$<Flag={0}>}CustomerID)

Count({$<Flag={1}>}CustomerID)

I hope this helps! Let me know incase of any concerns/questions.

Thanks,

Sibin Jacob. C

[#4]

hi all

thanks for your kindly reply... but one think i forgot to say is the dimension of my chart in this case is month ....

and for each month i want to show the count of customer that the previous flag for them is 0 and current flag is 1 ... actually this diagram suppose to show churn ...

Regards..

saha