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

    Sorting Issue

    Aneesha Bhabak

      Hello,

       

      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

      Time_Zone:
      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.

       

      Regards,

      Aneesha