This content has been marked as final. Show 2 replies
I have a feeling I'm missing something obvious here, so I'm hoping one of you can help me out:
I have a table with the following fields:
My end goal is to create a chart with a dimension of days (every day in the calendar, starting from the earliest Opened_Date), and two expressions: 1) The Count of Notices that were opened on the day in question, and 2) The Count of Notices that were closed on the day in question.
I'm not sure how to create a calendar that will connect to the existing table, and let me check if Opened_Date = [Whatever Date Field is Called] and Closed_Date = [Whatever Date Field is Called].
Any thoughts? Thanks in advance!