Forum Discussion
Count(distinct) not working
Hi I'm having trouble getting Count(distinct) to work. I have a table that i would like to get a count of the distinct project numbers and the total of lab hours associate with each distinct project ...
Hi, thank you very much for the quick replies and taking time to look at my problem. The command works fine if I were to run it on a seperate standalone .xls table but it doesnt run within the report I built. It may be a problem of it looking at my entire data cube/data set rather than just the info that i have filtered to my table and i dont know how to get around that. If i run the command in a seperate (card) visualization it comes back with 1.02 million.. I do not have any page level or report level filters just the 5 visual level filters and values you see in the table headings. I am also running 4 slicers for test recievd week, test completed week, and 2 lab identifiers.
Thank you for your help !