I have several reports that are currently manually put together and I'd like to display them in Domo with regards to Case Open Date and Closure Date. the 2 dates I have are open and closed date along with the Case detail information. I need to aggregate the data to show this below. So here's what the current report looks like:
Month | # of Cases Opened that month | # of Cases closed that month | # of cases open at eom
Jan 45 35 15
Feb 55 42 9
.
.
The column: month is related to both closed and opened date on one line. How do I show this data? How would I show the last column? I'm just needing a little help to understand how to show this in Domo. Thanks, Wendi