I’m trying to create a stacked bar chart that is monthly aggregated.
I have the following colums : startdate, enddate, count(client), count(x-client)
A client is someone that his enddate hasn’t arrived yet and of course an x-client is not with us anymore (enddate passed).
I’d like to check our history for each month how many clients we had and how many left.
How would you go about doing this?
Thanks in advance