I have data for the user regarding his subscription transaction date.
suppose if the user has a monthly subscription and the subscription date in on 4th of every month.
Then how can I count that user as an active user for 4th of every month
Subscription Date is auto-debit transaction date by the user.
What kind of visualization do you intend to build with this info? Normally you wouldn’t need to project subscriptions in this way. Instead you would SELECT data from your transactions table.