We are trying to build a report in Salesforce for the last 30 days that shows for each day, the amount of cases opened and the amount of cases closed(in total, not how many of the opened were closed). It's just a workload comparison for the support team, so how many cases in vs how many cases out.
Something like
Day 1 . 46 cases opened. 34 cases closed. Day 2 . 50 cases opened. 52 cases closed. [...] Day 30. 36 cases opened. 26 cases closed.
We'd graph that with side by side bars.
We can't get our way around to bucket those two different group by's. As cased closed don't necessarily belog to cases opened that day.
We tried grouping by cases open or closed.
