Hi,
I am trying to create transform with the scenario, grouping by every 15 mins and aggregation should be like as below.
Getting the count of the records for each filter. but not able to perform Sum or max on the filtered records.
aggs on filtered records not considering in transform script and deleting automatically from script. can some one help please.
"aggregations" :{
"TotalAgentReady" :{
"filter": {
"bool": {
"must": [
{
"term": {
"CallActionName": "READY_COMPLETE"
}
}
]
}
},
"aggs": {
"TotalAgentReadyTime": {
"sum": {
"field": "Duration"
}
}
}
},
"TotalAgentNotReady" :{
"filter": {
"bool": {
"must": [
{
"term": {
"CallActionName": "NOTREADY_COMPLETE"
}
}
]
}
},
"aggs": {
"TotalAgentNotReadyTime": {
"sum": {
"field": "Duration"
}
}
}
},
"TotalAgentLoggedIn" :{
"filter": {
"bool": {
"must": [
{
"term": {
"CallActionName": "SESSION_COMPLETE"
}
}
]
}
},
"aggs": {
"TotalAgentLoggedInTime": {
"sum": {
"field": "Duration"
}
}
}
}
}