Count in set Analysis

[dathathreya]

Hi all i want to count only of 1 value in a column.i have a dispute column in my table which it consists of 10lack rows .the data is like 0,1 in this column.now i want to count only 1 values in that 10 lakh records.

[sunny_talwar · Accepted solution]

Why do you need set analysis if the values are 0s and 1s, may be just this

Sum(Dispute)

[dathathreya]

can u please give me a set analysis expression.

[sunny_talwar]

May be like this

Count({<Dispute = {1}>} Dispute)

[Anonymous]

Hi Sunny,

     But in the above case, we can also use Sum(Dispute) which u mentioned earlier. Right ?. Because , however sum() will sum only '1' by ignoring '0'. If I am wrong, please correct me.

[MindaugasBacius]

Use as stalwar1 suggested Sum(Dispute) as this consumes less resources and is a more simple than Set Analysis.

[dathathreya]

How to achive MOM with this?Please help

[Anil_Babu_Samineni]

Still you are facing issue? Can you tell us what kind of challenge you are expecting? Would you provide sample data set and tell us expected result

[dathathreya]

Hi anil i got solution for that thanks for your support .

[Anil_Babu_Samineni]

So, Then please close this thread by flag Correct Answer of your spot light answer which you feel