How to setup a time range

Question & Answer
1

Can anybody help me to set the start and end times for a given day?

I need to set the start time as 00:00 and end time as 23:59 for a selected day.

2

Hi @PandaDH ,
It is very simple just go to the your Date Filter section and select the Time Granularity & then select the Minute as Time Granularity.

image

Do this same process for both Start Time & End Time.

Thanks & Regards
Biswajit Dash

3

Thanks for the reply @Biswajit_1993 . Even I select the Minute granularity, it asks to Start date and End Dates. Can you please explain further.

image
image477×622 33.3 KB

4

Hi @PandaDH ,
OK no issues for this you need to follow some steps.

Step - 1

you need to create two DateTime parameter and on the filter section put the Date field and select the filter type as Date Time Range and condition as Between.

Put both Start Date parameter and End Date Parameter as picture below.

image
image194×520 15 KB

Step -2

Then go to parameter section and select both parameter as parameter control on the analysis

image

Step -3

Then go to Start Date parameter control and set the time as 12:00:00

image

In the same ways you can set the time for the End Date Parameter

image

Note - On both the parameter I have selected today as the default date you can change the date as per your choice so that you can get your desired result.

Thanks & Regards
Biswajit Dash

1 Like
6

Thanks @Biswajit_1993 it works. However I use a slider to define the time slot duration as follows.

image

When I select time duration as 176 (as an example) report gets as follows.

image

image

As you can see the first row is not staring from 0:00 insted it goes to previous day 21:20. Also last row End Time goes to next day.

However, for dynamic minutes of 1, 5, 10, 15, … 1440 it shows correctly (starts from 0:00 and ends 23:59).

Can you please help me to fix this issue.

7

Hi @PandaDH ,
Just to confirm one thing from your sides like for this scenarios how many date field you have like you have two date field one is for Start Date and another is End Date or you have only one Date Field?

Thanks & Regards
Biswajit Dash

1 Like
8

Hi @Biswajit_1993, I only have one Date feild.
User should be able to select a required Date, required time range within that date and required time slot duration (dynamic minutes) within that time range.

Thanks.

9

Hi @PandaDH, I am not sure I fully understand your requirement. Can you share sample data and mock up of what you are trying to achieve here? It looks like you have one date column and you want to dynamically add/subtract minutes from that date? If you are able to mock up something it will help for better understanding.

Regards,
Karthik

2 Likes