count connexion with startdate and endate

[Obs_vdf_paris]

HELLO please if you can help me 

i have user with session start and end 

user StartDate EndDate
1 2020-03-03 06:12 :27 2020-03-03 14:46 :04
2 2020-03-03 07:05 :34 2020-03-03 07:55 :19
3 2020-03-03 07:19 :06 2020-03-03 14:48 :13
4 2020-03-03 09:37 :36 2020-03-03 10:38 :28
5 2020-03-03 12:10 :15 2020-03-03 12:22 :34
6 2020-03-03 14:35 :28 2020-03-03 16:31 :02
7 2020-03-03 14:46 :05 2020-03-03 14:56 :52
8 2020-03-03 14:51 :37 2020-03-03 15:30 :00
9 2020-03-03 14:51 :41 2020-03-03 21:39 :45
10 2020-03-03 14:52 :42 2020-03-03 16:14 :15
11 2020-03-03 15:13 :49 2020-03-03 20:28 :02
12 2020-03-03 15:33 :28 2020-03-03 15:38 :37
13 2020-03-03 18:04 :40 2020-03-03 18:07 :11
14 2020-03-04 12:32 :26 2020-03-04 21:35 :01
15 2020-03-05 06:43 :25 2020-03-05 06:59 :20
16 2020-03-05 07:09 :59 2020-03-05 21:34 :51
17 2020-03-05 20:23 :50 2020-03-05 20:24 :45
18 2020-03-05 20:25 :09 2020-03-05 20:26 :52
19 2020-03-05 20:27 :20 2020-03-05 20:28 :27
20 2020-03-05 20:31 :36 2020-03-05 20:32 :36
21 2020-03-05 20:52 :33 2020-03-05 20:53 :25
22 2020-03-06 06:49 :33 2020-03-06 15:55 :28
23 2020-03-06 07:57 :41 2020-03-07 00:18 :03
24 2020-03-06 10:07 :57 2020-03-06 16:10 :51
25 2020-03-07 07:46 :42 2020-03-07 08:02 :35
26 2020-03-08 10:23 :29 2020-03-08 10:25 :12
27 2020-03-08 10:25 :13 2020-03-08 10:30 :54
28 2020-03-08 10:27 :59 2020-03-08 10:32 :08
29 2020-03-08 16:24 :56 2020-03-08 16:26 :42
30 2020-03-08 16:26 :43 2020-03-08 16:28 :26
31 2020-03-08 16:32 :22 2020-03-08 16:33 :18
32 2020-03-08 16:33 :23 2020-03-08 16:35 :14
33 2020-03-09 07:31 :48 2020-03-09 19:53 :48
34 2020-03-09 08:10 :48 2020-03-09 18:48 :01
35 2020-03-09 19:09 :08 2020-03-10 03:23 :44

I will try to find out how many users I have actif in at a specific time on a graph(at 8H00. 9H00 ......20H00)

like here 

1 2020-03-03 06:12 :27 2020-03-03 14:46 :04
2 2020-03-03 07:05 :34 2020-03-03 07:55 :19
3 2020-03-03 07:19 :06 2020-03-03 14:48 :13
4 2020-03-03 09:37 :36 2020-03-03 10:38 :28

at 9H i have 3 user connected 

I tried to create a table which calculates the number of user connected in different hours but I did not succeed

can you help me please please 

[lorenzoconforti]

See example attached based on your data; have a look at the formulas in the table to see how it is implemented

[Obs_vdf_paris]

the example is just a sample I have 30000 LINE of a citrix database
I want to calculate the number of active session based on startdate and anddate

i wan like axes X :  hour and date

axe Y : count nombre of user actif ( where hour and date is between startdate and endate)

[lironbaram · Accepted solution]

hi 

attach is an example of what you asked 

it's using intervalmatch function 

[Obs_vdf_paris]

hello lironbaram it's work  THANNNNK YOU VERY VERY MUCH

I have another question sltp I would like to take the maximum hour connection and display it on the date example:

day 03/03/2020  i have 13 USERS BUT 

03/03/2020  the max of user connecte in same time it's 4 at 12H

04/03/2020 the max its at 12H  it's 1

I WAN in 

axe X : timestamp.autocanlender.date

in Y : Max of connexion (user connected the same time ) like for 03/03/2020  i have 13 USERS BUT wan affiche 4 NOT 13 

?

THANK YOU V

[lironbaram · Accepted solution]

hi

i didn't understood your question , 

for each date , you want to display only maximum of concurrent users ? 

if so you can do it like this 

max(aggr(Count(user),TimeStamp,[TimeStamp.autoCalendar.Date]))

if a reply is correct please mark it as answered, so other users can benefit from the solution 

thanks 

[Obs_vdf_paris]

thank you lironbaram 😉