4 Replies Latest reply on Feb 28, 2017 10:35 AM by Chrissy Scott

    Common Date Field

    Chrissy Scott

      Hi All,

       

      I am working on a view to show requests opened per month and requests closed per month. I want to show both in one viz where each month has two bars, one for opened and one for closed. How do I do that when opened and closed requests have separate date fields?

       

      I can create simple views for Opened by Month and Closed by Month using the relative Opened Date/Closed Date:

       

               

       

      I want something like this, but instead of complete/canceled, it's Opened/Closed:

      Can I do that with separate date fields? I feel like I need a common date field but not sure how to create that. Any ideas?

       

      Thanks,

       

      Chrissy

       

      PS - I'd attach a workbook, but it's ODBC so can't be opened.