Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Please assist i need to display time in below graph to be hourly e.g 8:00,9:00,10:00,11:00,12:00,13:00?
Thanks
Is it that important for the OP to see :00. If it is, then i would just use this instead of making the field text
Time(Floor(grab_time, 1/24), 'h:mm')
May be attach to test?
=floor('Time field') in the dimension use it
Hi Anil
Thank for your quick response below is format of my time?let me know if you need more info.
20:49:25 |
20:50:25 |
11:53:39 |
12:07:56 |
12:47:46 |
12:51:37 |
18:51:42 |
11:35:37 |
09:16:42 |
10:10:57 |
10:38:36 |
14:00:03 |
14:00:08 |
13:50:53 |
08:33:10 |
16:58:32 |
17:37:56 |
16:13:16 |
17:34:26 |
17:35:21 |
11:35:41 |
15:33:21 |
16:18:14 |
16:22:44 |
18:10:32 |
18:10:35 |
18:10:36 |
18:16:09 |
If possible, Please attach QVW that may demon the issue
Hi Mahesh
Thanks,
After applying what you suggested my graph went blank. my Time field is grab_time.
i used below in my dimension
=floor('grab_time')
check here same requirement matching here
Have you tried Hour() function in your dimension?
Hour([grab_time])
small addition
he want with : 00 so you can this also to sunny answer i think
=hour('Grab_time')&':00'
Is it that important for the OP to see :00. If it is, then i would just use this instead of making the field text
Time(Floor(grab_time, 1/24), 'h:mm')