Best way to display time filter

Dwayne Cooper shared this idea 3 years ago
Awaiting Reply

I'm creating a report that I want to allow the user to filter by a date and time range. Typical filtering would be something like June 1, 2017 at 10am to June 2, 2017 at 2am. I have a timestamp so I can do the filtering (see attached) but it's rather awkward for the user to specify the time. Is there a better way?


Thanks,

Comments (6)

photo
1

Hi Dwayne,


My apologies on the delay here. You have two main options in this case aside from the normal date picker route.


  • Predefined filters: This is very nice when working with current data, as "today" makes far more logical sense than BETWEEN "19/6/2017 0:00AM and 20/6/2017.."
  • Dynamic Dates: current date + 0 days, et. This is nice if you are looking for a little more customization to pre-defined periods


If you have considered both of these and neither meets your needs, It would be helpful if you could elaborate slightly on what you are wishing for. If yo would like more information on either of these let me know!


Regards,

Nathan

photo
1

Hi Nathan,


I have tried/considered those and the date picker actually works but it's tough for the user to change the time portion. I've attached a screenshot of the old reporting interface so you can see what I'm after.


Thanks,


Dwayne

photo
1

Hi Dwayne,

While you could use some fancy SQL to split the day and time, I think that the best solution here will be to work within the confines of the current date picker. As I agree that the time portion of this could use to be more clear, I am going to convert this into an idea.

Once the product team has a chance to review this, they will let you know if this is something that can reasonably be included in the program.

Sorry for the inconvenience, and please let me know if there is anything I can do to help in the meantime.

Regards,

Nathan

photo
1

Got it -- thanks!

photo
1

Hi Dwayne,


Just responding on behalf of the US as they're not in today.

I can say that this idea has been officially logged in our system which will be reviewed in the future.


Any changes on the task will be reflected here.


Please let us know if there was anything else you were after in the meantime.


Regards,

David

photo
1

Thank you.

photo
photo
1

Hi, I was reading this thread as we had a similar issue and wanted to share how we worked around it in case it helps other users.

We had a similar issue whereby the user wanted to be able to specify the time range for the predefined date range "today" and save this as a Bookmark. The problem was that when you pick "Today" from the predefined list it doesn't allow you to specify the time range. Using the datepicker and picking the current date via the calendar control does allow you to specify the time range but then when you save it as a bookmark the date is then also saved as a hard coded value.

We managed to work around this by modifying the view in YF and adding a Virtual Table that selected a column that we could make a join on and also converted the timestamp field to a time (See YFModifiedView.PNG).

After joining the Virtual table with one of our other tables, we then added the Time field to the view as a Dimension in the Filter category.

Edited the report - Dragged the new filter in to the report filter section and formatted accordingly.

The result is that we can now specify a predefined date range and easily set the time range for which data should be returned.

(See YFTimeFilter.PNG)

photo
1

Hi Nigel,

Converting this to a time, and then displaying that as a separate filter does seem like a good alternative here.

Thanks for sharing!

Nathan

photo
1

I agree -- I'll give it a try.

Thanks!

Dwayne

photo