Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculating New and Returning users

Hi,

 

I am trying to calculate the number of new vs. returning users but cannot figure out how to for the life of me. I have created three different measures based on three different tutorials and all give me a slightly different result so I'm hoping someone can tell me the definitive answer here. 

I have two tables ('in' and 'dates'):

  • 'in' contains user activity data: which users clicked on what application within the platform on what day
  • 'dates' is my separate date table that I want to use to filter the results

They are connected via the date column:

All I want to do is to calculate the number of new vs. returning users on the platform and be able to slice this number by the different applications and date intervals (e.g. last 3 months). Preferably I'd like to be able to drill down and see a monthly, weekly, daily breakdown.

 

What would be the best way to go about it?

Need Help

1 Reply

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi rginny, 

    If possible, could you please inform me more detailed information (such as your sample data and your expected output)? Then I will help you more correctly.

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.