3 Replies Latest reply: Apr 7, 2017 3:18 AM by Aneesha Bhabak RSS

    Sorting Issue

    Aneesha Bhabak



      We were trying to create a chart that displays hours from today 4AM(Day) to next day 9AM(Day+1). We were taking a inline table to load this

      LOAD * INLINE [
      Time, date_gateCount
      05:00, Day
      06:00, Day
      07:00, Day
      08:00, Day
      09:00, Day
      10:00, Day
      11:00, Day
      12:00, Day
      13:00, Day
      07:00, Day+1
      08:00, Day+1
      09:00, Day+1


      However we are using the match() function but the chart is not coming properly accordingly time 4AM to 9AM.I think there is a sorting issue between these two fields date_gateCount and Time.



      Kindly suggest.