I have a table in my database that records, 48 times per day, the total users, total active users within 2 weeks, total users logged in within the past 24 hours , and total users that logged in within the last 24 hours that had visited the site prior to the last 24 hours.
I'm trying to use this data to calculate the churn rate of my users, but in some cases I am getting a negative number so I assume I am doing it incorrectly.
My attempt:
(Yesterday's active in past 24 hours [returning] - Todays's active in past 24 hours [returning] + Change in Active Users) / Todays's active in past 24 hours [returning]
I assume I have the correct data somewhere with all of the data I am saving, I'm just not using it the right way.