I have a question that might be easily answered, but unfortunately, i have not been able to find the solution to the problem:
- I currently have a table that shows the data per day per client ID.
- I have a date filter to only show the data of a month at a time
However, when there is no data, it needs to show the data on the last date there actually was data. In this case, the last moment there was data, this was present on the previous month.
How can i show this?
When you apply a filter the data are eliminated from the table that underlays the viz and is no longer available in the calculation
one approach is to Hide the data (the date you don't want to show) after you complete the viz - another would be us use sets and not filters -
there are many examples of each in previous post on the forum
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...