3 Replies Latest reply: Dec 10, 2014 12:51 PM by Bill Markham RSS

    Show Active Users by month with type 2 table?

    Nate Brunner

      I am trying to create a bar chart that shows Active Users by month. The data I have is in a type 2 dimension with Start and End Dates, with the most current row having a null End Date.

       

      What would be the most efficient way to try and show active users by month over a years time, or rolling 12 months so that I don't have to try and hard code dates into the logic or count up the users with some massive if statement.

       

      Thanks in advance for help.