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?