I posted a question last week and got an answer right away, so thank you for that! I have kind of a follow-up question:
Here is my original question post: Calendar for table with two dates
Following that post, I now have 3 tables:
The next thing I need to do is create a chart with a dimension of each day in the calendar (starting from the earliest OPENED_DATE), and an expression that counts the number of notices that are open on the day in question (i.e. OPENED_DATE <= [Whatever Date Field is Called] and CLOSED_DATE > [Whatever Date Field is Called]). Is there a way to do that? Thanks in advance!