All the examples that I've seen for Multi-Pass Aggregation demonstrate it being used directly on numeric data. Is it possible to use it on a Count or DupCount calculation?
I have a very simple Pivot - the Row is a list of Dosages (text) and the Value is a DupCount of those Dosages. I would like to add an additional Value which would show the percentage of the total represented by that Dosage, but the formula editor keeps telling me that I can't use the Dosage field twice.
I know this must be possible since the Pie Chart does it automatically (and, yes, I would love to just stick in a Pie Chart here but our client has pretty strict requirements and we are trying to move them gently over to Sisense).
This is what I would like to end up with:
Dosage Count Perc
50mg 2 20%
100mg 5 50%
80mg 3 30%
Is this possible?
Please sign in to leave a comment.