December 15, 2015
Tableau Tip Tuesday: How to Calculate Week over Week Change of the Last Complete WeekHashu Shenkar, one of my former Data Schoolers, asked while he was working with me:
How do I calculate the week over week change for only completed weeks? And how to I show only value for the latest complete week.This required several table calculations, and I'm pretty certain that there's a better, more efficient way to calculate this with LOD calcs. However, I couldn't figure out how to get the LOD calc to work, so I got the result the way I would have before LOD calcs existed.
If you know a better way to accomplish this, please leave a comment. Enjoy!