Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
I want create a time range dimension to have the following values in 30 minutes range:
7:00 AM
7:30 AM
8:00 AM
8:30 AM
until 11:30 PM
So I have a time field that shows for example
07:15 AM
3:23 PM
4:54 PM
If I select 7:15AM I should see this date under the 7:00 to 7:30am slot.
I created an inline like this but it is not working when I do the intervalmatch with the time field from my database.
LOAD * INLINE [
Start, End, Slot
07:00, 07:29, 7:00 AM
07:30, 07:59, 7:30 AM
08:00, 08:29, 8:00 AM
];
It looks like the interval match works with numbers but when I use time it doesn't work. Any suggestion of what is the formatting to use?
Thanks Marco. This was very helpful.
you're welcome
regards
Marco