Matrix aggregate question

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:

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?

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