Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Add time to date range slicer

This is my sample data

Date Count

02/05/2022 10:05:36 AM

10
02/05/2022 11:05:36 AM15
02/05/2022 12:05:36 PM20
02/05/2022 01:05:36 PM20
02/06/2022 10:05:36 AM15
02/06/2022 11:05:36 AM10
02/06/2022 12:05:36 PM15
02/06/2022 01:05:36 PM10
02/07/2022 10:05:36 AM10
02/07/2022 11:05:36 AM10
02/07/2022 12:05:36 PM20
02/07/2022 01:05:36 PM15

Filter: 02/05/2022 11:05:36 AM to 02/07/2022 12:05:36 PM.

There is only date range filter in a slicer. But there is no time integration. I can do it from advance filter. But that is not my requirement. I need it using custom slicer. I require the count information from 11:05:36 am of 5th february to 12:05:36pm of 7th february. I am stuck in this problem. Please help.