This content has been marked as final. Show 3 replies
I have a straight table that I am looking to show total counts of the # of documents associated with a certain type of "document type".
I tried using =if(DocType = 'DocTypeA', count(distinct(DocID))) for the first DocType expression, and substituted 'DocTypeB' and 'DocTypeC' for the other two expressions.
In some cases, it is working, but in cases that the 'Person' (my dimension) has multiple 'document types' , it will only show the first expression total.
Is this a problem that set analysis can solve?