I'm trying to calculate a difference between keys in name value pair data structure.
This is a very simplified example. The key is date and site. I would like to calculate a 3rd column that is Site A - B.
Does anyone know how to do this?
Here you go
You can download it and open it using 9.3 or the tableau public.
Make sure that you compute those window functions using Site dimension.
Retrieving data ...