I am unable to replicate the Active Subscriptions number from the dashboard chart.
From the transactions data obtained through the ETL exports, I have tried the SQL example found here, as well as variations of it, but the result always differs from what’s in the chart.
What are the calculation details for Active Subscriptions?
Solved
How can Active Subscriptions be calculated from Transactions data?
+1Best answer by tina
The ETL query should show you the number of active subscriptions that you have. Have you tried changing end_time > NOW() to end_time > ‘2021-12-08’ ? In addition, have you waited for the chart to update before running the query? You can see the last updated timestamp when you hover over the info icon:
This post has been closed for comments
+10The ETL query should show you the number of active subscriptions that you have. Have you tried changing end_time > NOW() to end_time > ‘2021-12-08’ ? In addition, have you waited for the chart to update before running the query? You can see the last updated timestamp when you hover over the info icon:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.