Beating my head against a wall, hoping I'm missing something obvious. Using api/v2/analytics/evaluations/aggregates/query and attempting to return the evaluationReleaseDate in the groupBy... yes, it's high cardinality, but it's a customer requirement. Seems straightforward enough, right? Where did I go wrong?
Per the documentation
groupBy
( array, optional ): Behaves like a SQL GROUPBY. Allows for multiple levels of grouping as a list of dimensions. Partitions resulting aggregate computations into distinct named subgroups rather than across the entire result set as if it were one group. Valid Values: calibrationId, contextId, conversationId, conversationStart, divisionId, evaluationCreatedDate, evaluationId, evaluationReleaseDate, evaluatorId, formId, queueId, released, rescored, teamId, userId
However...
{"interval": "2021-08-21/2021-08-28",
"groupBy":["conversationId","userId","evaluationReleaseDate"],
"metrics": ["nEvaluations", "nEvaluationsDeleted", "nEvaluationsRescored", "oTotalCriticalScore", "oTotalScore"],
"flattenMultivaluedDimensions": true
}
returns...
{
**"message": "unsupported groupBy dimension evaluationReleaseDate",**
"code": "bad.request",
"status": 400,
"messageParams": {},
"contextId": "72618c9c-1eb4-4893-baf7-b232b541882b",
"details": [],
"errors": []
}