I'm writing a DQL query to fetch dt.davis.problems and filter it by Management Zone to create a panel in the new Dashboard app similar to the Classic Dashboard app.
This is what I've written so far to get the Davis problems by status.
fetch dt.davis.problems
| summarize count(), by: {event.status}
I'm trying to add a filter by management zone but don't see any fields in dt.davis.problems that correspond to management zone. So how do I add a filter to this DQL to show problems for a particular management zone only?
Thank you!
