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?
Best answer by tinaView original
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: