There is a "Tableau Classics" posted by Joe Mako here:
Please find the attached wb with a slightly adopted version of it.
Rolling Count Distinct_YF.twbx 666.4 KB
Thanks for the workbook. That is a very cleaver way to accomplish the rolling count distinct.
It seems there is one limitation on this method though. It seems like you can only count distinct on one dimension per worksheet.
Is that correct?
For example, you wouldn't be able to do a (Rolling Count Distinct Product Category ) / (Rolling Count Distinct Customer IDs), right?
1 of 1 people found this helpful
You're right, mixing two non-additive table calcs on one view
with a different granularity for each one is at least problematic if possible.
I've spent some time trying to build Rolling Count of Distinct [Item]
along with Rolling Count of Distinct [Customer ID] on one view -- no luck. sorry.