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

    30min time bucket and measure per minute

    raoul.tller

      Hi,

       

      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).

      permin.png

       

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

      30minbucket.png

       

      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