Hello I'm having a hard time figuring out if the aggregate functions would be able to achieve what I'm trying to do. It's hard to explain in text format, but I created a simple image: https://imgur.com/a/YPXmrBI
Basically I'm trying to group all records by assigned_user and count how many documents they have for each of the given statuses.
Is something like this possible with ES given the document structure?