A common use case when looking at log files or data for ticket requests is to see how many items are open at any given time. Luckily we can show this by utilizing a couple of tricks in Tableau.
For this example we will use the Sample Superstore data and look at how many orders have been placed, but not shipped yet.
First we need to duplicate the Superstore data through a union:
Next step is to create a calculated field for Orders Not Shipped:
We need a Date Field that combines the two dates we are looking at:
Create a running total of the Orders Not Shipped calculation, and we get this final result:
Quick and simple. This will also work for dimensions and other calculations in the viz:
No responses yet