I have a table called "HelpDeskIncidents" that includes columns such as "OpenDate" "ClosedDate" and "IncidentNumber"
I want to be able to show, in one visual, the number of tickets opened AND closed within a certain date period. So if I have a graph it would show that on January 2, 2018 there were, let's say, 36 tickets opened and 28 closed.
I'm not sure how to write these measures any help is greatly appreciated.
Oh, I have a date table and I have the "OpenDate" as the key with the date table if that helps
Create 3 date tables. Date table 1 (Calendar1) relate to OpenDate in your table. Create a column in this table that does a count of RELATED or RELATEDTABLE. Date table 2 (Calendar2) relate to ClosedDate in your table. Create the same column in this table. Date table 3 (Calendar3) relate to Calendar1 and Calender2. Use Calender3 in your Axis and the values from calculated columns in your other 2 date tables.