Represent Open vs Closed Tickets by Month
I'm not sure if this should go in Beast Mode or in Card Builder but I will start here. We have a data source that has one row per Ticket#. We would like to show Open Tickets vs Closed Tickets by month on one card. The problem that we have is that there is only one date that we can choose (Created Date or Closed Date). I know I'm missing something and can't get it to work for some reason. I used Beast Mode to get MonthName from Created date but if I use that as my basis, it will only show tickets that were created in June and Closed in June. I just can't seem to get it to work. I was just going to create a new datasource that would do it for me (i have completed it in SQL) but I'm trying not to create a new data source for one card. Any ideas are much appreciated.
Thanks in advance