Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is your sort expression?
please post a sample application to demonstrate.