1 of 1 people found this helpful
When you use a regular filter in Tableau, that filter is applied within the query that Tableau issues to the data source, so Tableau never gets the data to make the calculation. For cases like this where you want to show data from multiple days inside a single days' results, there are three methods I can think of offhand:
1. use a discrete date header with a relative date filter to show the last 2 days
2. set up calculated fields for the measure that do the date filtering inside the calculations
3. use table calculations.
There are advantages and drawbacks to each, exactly what will work best for you is dependent on what other data you want to be showing in your table.
this helps my problem, thanks for the quick response!