I am trying to calculate the percentage which tasks have been delivered for accounts. Tasks may be performed more than once, however i am disregarding this as i am looking for completeness in the range of tasks. So if i have task 1, 2, 3, 4, 5 and 6 where 1, 2, 3 was completed but 3 was done twice, the calculation should still result in 50% completion not 66%. So I am trying to use DISTINCT as follows:
count (distinct [task name])
Which works when i've filtered down to 1 account. When unfiltered so i have more than 1 account it consolidates the count of distinct task names. So if account 1 and 2 had completed tasks 1, 2 and 3, it would give me a count of 3 instead of the desired 6. How do I get QV to count distinct task names per account??
