This content has been marked as final. Show 2 replies
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.