Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The total should be 21.
You should be able to simple group the three fields you want to count...and do a count(distinct Field1&field2&field3)
I would use count(distinct SHORT_MBO_NAME) instead.
Hope this helps!
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.
create a compound key?
Count(distinct (Field1 &'|'& Field2 &'|'& Field3))
Preferred method would be to create this multi field key in the load script
Thanks David. But it didn't work!!
You should be able to simple group the three fields you want to count...and do a count(distinct Field1&field2&field3)
Thanks David. It worked.
Great! Please mark Question as answered
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
Done. Thanks David.