Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi
attach is an example of what you asked
it's using intervalmatch function
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
See example attached based on your data; have a look at the formulas in the table to see how it is implemented
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)
hi
attach is an example of what you asked
it's using intervalmatch function
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
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
thank you lironbaram 😉