Legacy Dev Forum Posts

 View Only

Sign Up

Back to discussions
Expand all | Collapse all

User time Aggregate (for All users)

  • 1.  User time Aggregate (for All users)

    Posted 06-05-2025 18:13

    dkprado | 2018-02-09 19:17:21 UTC | #1

    Hi there. I'm looking for an interface to get the Aggregate of ALL users' times, for a given time frame. Basically, I need the total online time of each User, during this period.

    I thought the User Status Aggregate should give me that information, but it forces me to filter by ONE userid. Am I misinterpreting this interface, or should it work for all existing uiserid? When I try this way, I get error 500.

    { "interval": "2018-02-09T02:00:00.000Z/2018-02-10T02:00:00.000Z", "groupBy": [ "userId" ], "filter": { "type": "or", "predicates": [ { "type": "dimension", "dimension": "userId", "operator": "exists", "value": null } ] }, "metrics": [ "tSystemPresence" ] }

    Can you assist me? Thank you.

    tim.smith | 2018-02-09 21:12:27 UTC | #2

    You do have to provide a filter for user IDs, but it's not limited to one. Just use an OR filter:

    {
 "interval": "2018-02-09T07:00:00.000Z/2018-02-10T07:00:00.000Z",
 "groupBy": [
  "userId"
 ],
 "filter": {
  "type": "or",
  "predicates": [
   {
    "type": "dimension",
    "dimension": "userId",
    "operator": "matches",
    "value": "9ed7d9f6-0c59-4360-ac54-40dd35eb9c2f"
   },
   {
    "type": "dimension",
    "dimension": "userId",
    "operator": "matches",
    "value": "8c35c7da-440c-47b9-b9e3-658e5574a086"
   }
  ]
 },
 "metrics": [
  "tSystemPresence",
  "tOrganizationPresence",
  "tAgentRoutingStatus"
 ]
}

    system | 2018-03-12 21:12:35 UTC | #3

    This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.

    This post was migrated from the old Developer Forum.

    ref: 2487



Related Content