I'm getting wrong data for some accounts

[#1]

The total should be 21.

[jerem1234]

I would use count(distinct SHORT_MBO_NAME) instead.

Hope this helps!

[#3]

Hi Jeremiah,

count(distinct SHORT_MBO_NAME) wouldn't help because if I do that, all the statuses will be counted as 1 each which is not true. There are 48 accounts in total and each account has 7 MBO's and I have data for 3 months. So total should come up to 48*3*7= 1008.

[#4]

create a compound key?

Count(distinct (Field1 &'|'& Field2 &'|'& Field3))

Preferred method would be to create this multi field key in the load script

[#5]

Thanks David. But it didn't work!!

[#6 · Accepted solution]

You should be able to simple group the three fields you want to count...and do a count(distinct Field1&field2&field3)

[#7]

Thanks David. It worked.

[#8]

Great! Please mark Question as answered

[#9]

Good rule for the future is to name your forums with the specific question, so the next person with your problem can find the solution.

"Count the distinct of multiple fields" would be a good name - may want to change it

[#10]

Done. Thanks David.