7 Replies Latest reply: Sep 25, 2017 10:22 AM by Sunny Talwar RSS

    group by 15 minute intivals, but show negative times in 15 minutes

    Joanna Seldon


      Hi

       

      I have this as a measure

       

      count OrderID

       

      This as a dimension

       

      time(round( frac([OrderTimeMinutes]) + (7/1440), 1/24/4) , 'hh:mm')

       

      this shows on the

       

      but only showing positive time x axis in 15 minute intivals as

       

      00:00, 00:15, 00:30 as I want

       

      but some dates have been entered wrong in the system

       

      thus I should have time buckets of

       

      -00:15 , -00:30

       

      How do I get those to appear please

       

      Kind Regards