4 Replies Latest reply on Jul 13, 2018 1:42 AM by raoul.tller

    30min time bucket and measure per minute




      I have balance date every minute for multiple codes, I want to look at this per 30min time buckets, but the balance would automatically SUM in Tableau, I want to get the specific balance amounts for the 30min buckets (not summing).



      30min bucket: DATETIME(INT(FLOAT([datetime])/(30/1440))*(30/1440))



      How would I achieve this? It just always has to show me the balance of that specific minute?


      I have tried with this:

      IF {INCLUDE:MAX([datetime])}=[datetime] THEN [balance] END


      But it returns me the balance of 1:32 at 1:30 oddly