Why does the response from /users/aggregates/query come with "None" values?

Platform API
1

Hello!
I am using python SDK for POST /api/v2/analytics/users/aggregates/query HTTP/1.1 query

api_instance = PureCloudPlatformClientV2.UsersApi()
body = PureCloudPlatformClientV2.UserAggregationQuery() 
start_date = self.start_day()
end_date = self.now_time()
body.interval = f"{start_date}/{end_date}"
body.group_by = ["userId"]
body.metrics = [ "tSystemPresence"]
filter_ = PureCloudPlatformClientV2.UserAggregateQueryFilter()
filter_.predicates = []           
for id in sub_agents_statistic:
      user = PureCloudPlatformClientV2.UserAggregateQueryPredicate()
      user.type = 'dimension'
      user.dimension = "userId"
      user.value = id                
      filter_.type = "or"
      filter_.predicates.append(user)
  body.filter = filter_
  api_response = api_instance.post_analytics_users_aggregates_query(body)

And here is a part of the result:

"group": {"userId": "4e9d8b2d-24e7-4937-9661-60adba574fff"}}, {"data": [{"interval": "2024-08-12T00:00:00.000Z/2024-08-12T12:29:05.000Z",
"metrics": [{"metric": "tSystemPresence",
    "qualifier": "OFFLINE",
    "stats": {"count": "None",
     "count_negative": "None",
     "count_positive": "None",
     "current": "None",
     "denominator": "None",
     "max": "None",
     "min": "None",
     "numerator": "None",
     "p95": "None",
     "p99": "None",
     "ratio": "None",
     "sum": 41143457.0,
     "target": "None"}},
{"metric": "tSystemPresence",
      "qualifier": "AVAILABLE",
      "stats": {"count": "None",
       "count_negative": "None",
       "count_positive": "None",
       "current": "None",
       "denominator": "None",
       "max": "None",
       "min": "None",
       "numerator": "None",
       "p95": "None",
       "p99": "None",
       "ratio": "None",
       "sum": 670367.0,
       "target": "None"}} 
         ...

I need "max" and "min" values ​​but I always get None values.
I tried using Http requests instead of python SDK but the result is the same
Why is this happening? Is there another way to get "min", "max" values ​​for user states?

Thanks everyone in advance

2

The user aggregates only support sum.

You can see examples of this behavior all the way back in 2018.

The actual API returns blocks like;

            {
              "metric": "tSystemPresence",
              "qualifier": "AVAILABLE",
              "stats": {
                "sum": 4166402
              }
            },

Certain object oriented libraries translate that as Null/Nothing/None entries for the portions it doesn't supply.
You're the first person I've seen ask for the other metrics, there isn't even an Ideas entry for it if you want to request one or you could try Customer Care since it's an undocumented difference to the standard behavior of t-Metrics

Timers (starting with t ) and most observations (starting with o ) returned by aggregate endpoints (e.g. oSurveyTotalScore ) will have count , min , max , and sum .

3

Got it. Thank you very much for your answer

4

I also seen in this behaviour in agent summary performance, wrapup performance and ivr performance. When i was comparing our PBI's with GC performance views we noticed this and updated our documentation.

5

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