2 Replies Latest reply: Jul 26, 2017 10:45 AM by Nikhila Shankar RSS

    Calendar for table with two dates

    Nikhila Shankar

      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!