Oct
28
Calculating Period-To-Date/PoP with Indicators for Better Performance
[ This is a guest post by Hans Romeijn. This is a followup post to my recent post on calculating YTD/YoY, QTD/QoQ, MTD/MoM and WTD/WoW. Hans shows a practitioner's approach to the calculation with performance in mind.
Counting Consecutive Occurrences in Tableau
I was asked a question: How to find out the IDs that showed up consecutively 5 times during the last 14 days?
How would you solve it?
Here I came up with 2 solutions. The 2nd one is a little simpler.