I have monthly total active users from 3 different locations. the database doesn’t have timestamp and the way I query the data is based on the user startDate and endDate employment contract.
the total users from 3 different locations should be stacked in one bar, but mine is side by side as bellow:
here’s the snapshot of my queries, not sure this is the most efficient way for getting total active user for rolling 12 months. I am totally Newbie!
Your help will be massively appreciated! thank you