NA Business Team
Category
Report Builder
Product Version
7.2
Best way to display time filter
Completed
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,
Files:
Screen Shot 201...
I like this idea 
Hi Dwayne,
My apologies on the delay here. You have two main options in this case aside from the normal date picker route.
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
Hi Dwayne,
My apologies on the delay here. You have two main options in this case aside from the normal date picker route.
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
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
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
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
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
Got it -- thanks!
Got it -- thanks!
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
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
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)
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)
Replies have been locked on this page!