6 Replies Latest reply on Jan 25, 2019 2:53 PM by Shinichiro Murakami

    Live accounts at any given time

    Josh Behr

      I have data on accounts that includes 'Account Start Date' and 'Account End Date'.

       

      I want a count by day, month, quarter and year of the 'Account Name' that were live. 

       

      Live is just >= 'Account Start Date' & <= 'Account End Date".

       

      Having this could help me answer, how many accounts were live in December of 2015 or How many accounts were live in Q1 2019.

       

      I've looked at a lot of solutions, but i haven't found one that can help me with this yet. can someone help?