Forum Discussion

BSCHNEIDER's avatar
BSCHNEIDER
Regular Visitor
2 years ago

Connection Report - counting users at any given time

I have a list of users that are connecting to TeamViewer.  We have a limited number of lisences that is based on how many users are active at any given time.  I have the log on and log off times for ...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

What's your sampling rate?  Do you need this by hour?  by minute?

 

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

BSCHNEIDER's avatar
BSCHNEIDER
Regular Visitor
2 years ago
8613298302/6/2023 9:442/13/2023 20:05
15318047982/6/2023 9:442/13/2023 20:05
15318047983/1/2023 7:123/8/2023 10:24
8613298303/1/2023 7:113/8/2023 10:24
15318047982/22/2023 14:123/1/2023 7:12
8613298302/17/2023 8:562/22/2023 14:12
8613298303/8/2023 10:273/13/2023 10:23
15318047983/8/2023 10:273/13/2023 10:23
8613298302/22/2023 14:122/27/2023 1:37
15318047982/17/2023 8:552/21/2023 19:55
15318047981/23/2023 7:191/27/2023 10:07
8613298302/2/2023 7:402/6/2023 9:43
15318047982/2/2023 7:402/6/2023 9:43
10538097585/22/2023 8:305/25/2023 12:26
8619360265/23/2023 14:085/26/2023 17:02
8613298303/17/2023 7:333/20/2023 9:20
15318047983/17/2023 7:343/20/2023 9:07
8613298305/12/2023 9:215/15/2023 8:00
10300183978/8/2023 9:338/11/2023 6:43
15318047987/14/2023 11:137/17/2023 8:02
16427770177/14/2023 11:177/17/2023 7:53
18979491148/4/2023 15:518/7/2023 8:55
14425537656/16/2023 13:116/18/2023 23:18
10538097585/15/2023 11:495/17/2023 13:59
11593151168/16/2023 15:198/18/2023 16:02
6153164995/18/2023 20:485/20/2023 14:05
6153164993/13/2023 1:593/14/2023 19:08
9509521366/9/2023 14:156/11/2023 6:42
14134051826/16/2023 16:556/18/2023 5:14
15318047982/15/2023 7:102/16/2023 18:03
10538097588/3/2023 8:028/4/2023 16:59
16427770176/1/2023 7:456/2/2023 14:30
8613298303/15/2023 7:153/16/2023 13:28
15318047983/15/2023 7:163/16/2023 13:28
13756525098/24/2023 8:328/25/2023 13:32
5674288252/17/2023 7:512/18/2023 12:27
14367440711/30/2023 10:431/31/2023 14:34
18965249925/31/2023 11:456/1/2023 15:21
10538097586/1/2023 8:416/2/2023 10:58
  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    so "max unique users in the selected timeframe" ?

    • BSCHNEIDER's avatar
      BSCHNEIDER
      Regular Visitor
      2 years ago

      Yeah, maybe max number of users logged on at any given time for each day....

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        Or maybe I can interest you in a chart based solution?