I am trying to figure out a very simple query and im not having much luck. Most of the information I am getting from google relates to numbers, but how would I get a time series on bool values. For example active directory account. I have a dataset that has if the account is active:true/false and the date it was changed (so when a user left the company and the account was then set to inactive).
Any help would be much appreciated. Thanks