Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Time should be shown as 1-2AM, 2-3AM similarly till 22-23PM 23-24
Please help me with this.
Thanks,
Keerthi KS
check this attachment
What is your base data?
Can you share sample data?
Date and Time
2014-12-31 06:23:46.480
2015-01-01 04:34:51.893
2015-01-05 08:33:49.000
Hi Keerthi,
Please find the attachment for the solution
May be this:
Table:
LOAD *,
Time(Floor(Time, 1/24), 'h') &'-' & Time(Ceil(Time, 1/24), 'h TT') as TimeRange;
LOAD [Date and Time],
Time(Frac([Date and Time])) as Time,
Date(Floor([Date and Time])) as Date;
LOAD * Inline [
Date and Time
2014-12-31 06:23:46.480
2015-01-01 04:34:51.893
2015-01-05 08:33:49.000
];
Output in Table Box:
Thanks a lot Avinash.
Please send for the below format
6-9AM |
9-10AM |
10-11AM |
11- 12N |
12-1PM |
1-2PM |
2-3PM |
3-4PM |
4-5PM |
5-6PM |
6-7PM |
7-8PM |
8-9PM |
9PM -12AM |
12-6AM |
May be something like this for customized ranges:
Table:
LOAD *,
If(Time <= (6/24), '12-6 AM',
If(Time <= (9/24), '6-9AM',
If(Time <= (21/24), Time(Floor(Time, 1/24), 'h') &'-' & Time(Ceil(Time, 1/24), 'h TT'), '9-12PM'))) as TimeRange;
LOAD [Date and Time],
Time(Frac([Date and Time])) as Time,
Date(Floor([Date and Time])) as Date;
LOAD * Inline [
Date and Time
2014-12-31 06:23:46.480
2015-01-01 04:34:51.893
2015-01-05 08:33:49.000
];
please find the attachment for the solution
Hi Sunny,
Please find the attached QVW.
I am not able to get the Time Range.
Its showing but dates are not matching.
Please help me with this.
Regards,
Keerthi KS