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?
How can Active Subscriptions be calculated from Transactions data?
Hey
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:
![](https://uploads-us-west-2.insided.com/revenuecat-en/attachment/e46e91d4-7103-433c-be39-ababa43a8bd0.png)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.