topic Re: How to add filter for time range in a dashboard in App Development

How to add filter for time range in a dashboard

Sanket_Sharma — Sat, 16 Nov 2024 03:30:19 GMT

I am having a column as c_time in my app, which includes the time value from a timestamp in HH::MM format.

I want to provide customer a dynamic functionality to view the data in any time range.

For ex: how many user where logged in between 11 to 11.30

Re: How to add filter for time range in a dashboard

Taoufiq_Zarra — Wed, 22 Jan 2020 10:53:44 GMT

can you share a sample data ?

Re: How to add filter for time range in a dashboard

Sanket_Sharma — Fri, 24 Jan 2020 05:09:32 GMT

Sample data is provided here now what i want is a time range picker which can pick time in 30 min difference.

For ex- How many users were logged in 11:00-11:30.

Re: How to add filter for time range in a dashboard

Taoufiq_Zarra — Fri, 24 Jan 2020 08:56:06 GMT

you can use Intervalmatch
attached a qliksense proposal

the idea is to group users by intervalmatch and then count(distinct user)

I stopped in interval at 12:00:00 you can add the rest until 23:00:00 to finish the application.

Data: LOAD * Inline [ c_time, c_date, userID 10:00:00, 01/07/2020, user1 11:38:25, 01/07/2020, user1 10:48:25, 01/07/2020, user2 11:58:25, 01/07/2020, user2 12:00:00, 01/07/2020, user3 ]; Intervaltime: LOAD * INLINE [ Start, End, Interval 00:00:01,00:30:00,0 00:30:01,01:00:00,1 01:00:01,01:30:00,2 01:30:01,02:00:00,3 02:00:01,02:30:00,4 02:30:01,03:00:00,5 03:00:01,03:30:00,6 03:30:01,04:00:00,7 04:00:01,04:30:00,8 04:30:01,05:00:00,9 05:00:01,05:30:00,10 05:30:01,06:00:00,11 06:00:01,06:30:00,12 06:30:01,07:00:00,13 07:00:01,07:30:00,14 07:30:01,08:00:00,15 08:00:01,08:30:00,16 08:30:01,09:00:00,17 09:00:01,09:30:00,18 09:30:01,10:00:00,19 10:00:01,10:30:00,20 10:30:01,11:00:00,21 11:00:01,11:30:00,22 11:30:01,12:00:00,23 ]; inner Join IntervalMatch ( c_time ) LOAD Start, End Resident Intervaltime;

Re: How to add filter for time range in a dashboard

Sanket_Sharma — Mon, 27 Jan 2020 06:08:07 GMT

Hi Taoufiq,

I used the below script however the c_time is not getting loaded in intervaltime table due to which association is not getting created

Data:
LOAD

"USER ID",
"Query to BOT",
"Response From BOT",
"Bot name",
"Timestamp",
Time("Timestamp", 'hh:mm:ss') as c_time,
"Account Name",
"Not Responded / Liked / Disliked",
"Reason For Dislike",
"Intent ID",
"Dimension(user level)"
FROM [lib://AttachedFiles/Chatbot_10jan.xls]
(biff, embedded labels, table is Sheet1$);

Intervaltime:
LOAD * INLINE [
Start, End, Interval
00:00:01,00:30:00,0
00:30:01,01:00:00,1
01:00:01,01:30:00,2
01:30:01,02:00:00,3
02:00:01,02:30:00,4
02:30:01,03:00:00,5
03:00:01,03:30:00,6
03:30:01,04:00:00,7
04:00:01,04:30:00,8
04:30:01,05:00:00,9
05:00:01,05:30:00,10
05:30:01,06:00:00,11
06:00:01,06:30:00,12
06:30:01,07:00:00,13
07:00:01,07:30:00,14
07:30:01,08:00:00,15
08:00:01,08:30:00,16
08:30:01,09:00:00,17
09:00:01,09:30:00,18
09:30:01,10:00:00,19
10:00:01,10:30:00,20
10:30:01,11:00:00,21
11:00:01,11:30:00,22
11:30:01,12:00:00,23

];
Join
IntervalMatch( c_time )

LOAD Start, End
Resident Intervaltime;

Please find attached error SS

Re: How to add filter for time range in a dashboard

Taoufiq_Zarra — Mon, 27 Jan 2020 07:55:01 GMT

Hi, what I've sent is an example that needs to be completed. in Intervaltime: I stopped at 12:00:00, you have to do the same until 23:59 (add the other 23 lines). if you still don't get a result, you can send me a data extract to see

Re: How to add filter for time range in a dashboard

Sanket_Sharma — Mon, 27 Jan 2020 09:26:54 GMT

Please find the attached document. I have added the time interval upto 23:59. But start and end fields are not showing the correct data corresponding to c_time. Kindly check and do the necessary action.

Re: How to add filter for time range in a dashboard

Taoufiq_Zarra — Mon, 27 Jan 2020 09:32:21 GMT

can you send me data other than a PDF to try to load it and see the error?

Re: How to add filter for time range in a dashboard

Sanket_Sharma — Mon, 27 Jan 2020 09:57:49 GMT

Please find the attachment.

Re: How to add filter for time range in a dashboard

Taoufiq_Zarra — Mon, 27 Jan 2020 10:39:18 GMT

sometimes we don't know how 🙂 but the attached version works fine. in load Data: use: Maketime(Hour(Time("Timestamp",'hh:mm:ss')),Minute(Time("Timestamp",'hh:mm:ss')),Second(Time("Timestamp",'hh:mm:ss'))) as c_time,

Re: How to add filter for time range in a dashboard

Sanket_Sharma — Mon, 27 Jan 2020 11:12:49 GMT

Thanks alot. This works fine.