1 Reply Latest reply on Jun 13, 2016 3:57 AM by khalid norat

    Using date filters while handling missing data

    Isha Kadu

      I am covering up the missing data for certain dates by using the data from the previous data as follows:

       

      IFNULL(expression,PREVIOUS_VALUE(expression))

       

      This works very well in the day view, but since the value of my aggregate function does not sum to NULL for the month/year view, this trick is not working in my dynamic month/year view.

       

      Is there any way to solve this in Tableau?