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



      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