I'm trying to create a card that shows the trend of case completion against a backlog each month (based on open/close dates). Ideally, it would be a multi-line chart with 'month-yr' on the X-axis and COUNT of cases on the Y-axis, for the following series:
- New = COUNT of cases opened during month
- Closed = COUNT of cases closed during month
- Backlog = COUNT of total remaining open (no close date) at end of the month
Is this possible? Not really sure how to tackle the aggregation of the backlog each month with beast mode.