0 Replies Latest reply: Jul 31, 2017 1:59 PM by Nikhila Shankar RSS

    count open notices by day

    Nikhila Shankar

      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:

       

      tables.PNG

      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!