How can Active Subscriptions be calculated from Transactions data?

  • 2 December 2021
  • 1 reply

Badge +1

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 tina 8 December 2021, 22:43

View original

1 reply

Userlevel 5
Badge +10

Hey @Étienne Tremblay 

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: