Separating Date and Time and allowing the user to select each as needed can be a powerfull analytical tool. The goal is to allow focusing on data for an arbitrary continuous range of Times within a Date, across a range of Dates.
Here's what I need: a way to allow the user to select either a single TimeOfDay at Hour and/or Minute and/or Second granularity, or a range of TimeOfDay, either before or after selecting a range of Dates at Date granularity. After reading said discussion I remain mystified. It's not clear to me how Sam's referenced discussion answers the op's question. Some of us are working the fine details.Ĭome on Microsoft. If the Date slider variant of slicer can convert date values into a slider, then surely it can't be beyond the wit of man to do the same with the decimal time values? Not all of us are looking at data over fanancial years. This gives a value between for all times, which will then act as a sliding slicer, but it still won't work over different dates. Slicervalue = hour()&format(minute(),"00") formatted as whole number The same goes for Filters, which can't deal with times at all other than manually selecting the required minutes in a Basic filter, which is not practicable for a 15hour sample. I need to be able to slice it between 1700 on one day and 1700 on a subsequent day and a slider would be the most obviously user-friendly way of accomplishing this. I have large date/time stamped data tables which build over 24 hours every day. I would also like to see the ability to slice by time as well as date.
0 kommentar(er)
