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?
Hi,
please close this thread and proceed with this discussion in your thread
thanks
regards
Marco
You can also use the Class() function in this case
Hi,
please close this thread and proceed with this discussion in your thread
thanks
regards
Marco