1 Reply Latest reply on Jan 9, 2019 5:03 AM by Jim Dehner

    Show value previous date

    Geert van der Weide

      Dear all,

       

      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?

       

      Kind regards.

        • 1. Re: Show value previous date
          Jim Dehner

          Good morning

          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

          Jim