Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hei.
I need some help because I am struggling with this issue for a while.
I do have a data table like:
The expression is like this:
I would like to group by the results according to City. The result should be divided into hours.
My result that I wish to accomplish is like this:
If that's possible would like to get the output in front end.
Could anybody help my out?
Thank you!
Does this look right?
Slight improvement of code here:
LOAD ID,
Date2,
Time2,
Date1,
Time1,
City
FROM
[test (2).xlsx]
(ooxml, embedded labels, table is Sheet1);
Time:
LOAD Interval(TimeStamp(MakeDate(Year(Today(1)), Month(Today(1)), Day(Today(1)) + Floor(RecNo()/24)) + MakeTime(Mod(RecNo(), 24))) - Today(1)) as Time
AutoGenerate 30;
Looks perfect!
Thank you a lot.
No problem at all