Same in Qlik, the one I use the most. SQL is good for this but few seem to use it and it's not very accessible.

Check out Red Wine Supernova, I quite like that one.
www.youtube.com/watch?v=VS6i...