Calendar for table with two dates

[#1]

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:

• Notice
• Concern
• Opened_Date
• Closed_Date

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!

[ahaahaaha · Accepted solution]

Hi,

May be this help you Canonical Date

[#3]

I think this is exactly what I needed, thank you!