Forum Discussion
Filtering on times
okay so you want to check out the new August product release video - where it demos the new range slicer.... it creates a measure that has values that you can use.... just watched it myself. can't help you further in this as it is new to me but check it out and then see if it advances your cause......
Hi CahabaData
Thanks for replying :)
I understand the logic you mentioned, my difficulty is now how would I filter that in a report.
For example I would like a slicer as follows:
I would use the above slicer to identify the hours and then a seperate (or inclusive if I use decimal values) slicer for the minutes.
It would then check the times within the table containing the Time In (TI) and Time Out (TO) to say that that time is between TI and TO and therefore would show that ID x would be in location y.
Thanks,
J
okay so you want to check out the new August product release video - where it demos the new range slicer.... it creates a measure that has values that you can use.... just watched it myself. can't help you further in this as it is new to me but check it out and then see if it advances your cause......
Have done :)
Seems like this new release has come at just the right time.
Thanks for the help anyway