2 Replies Latest reply on Jul 17, 2016 10:26 PM by nigora.sharipova

    Hide Incomplete Hour

    nigora.sharipova

      Hi,

       

      I am trying to hide the data for the incomplete hour. I used the following formula:

       

      if ATTR(DATETRUNC('hour', [Date])) = max(DATETRUNC('hour', [Date])) then LAST()==0

      END

       

      It works for the latest date; however, it always removes the 11PM hour for all the prior days. I thought it could be because Tableau is considering 11:59:00 as incomplete and excluding it from my data set. I truncated the date to the hourly level; however, my formula still does not return correct value.

       

      I would appreciate your help on figuring this out.

       

      Thanks!