Best way to display time filter

Dwayne Cooper shared this idea 2 months ago
New

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 (4)

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!