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

    Hide Incomplete Hour




      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



      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.