Question

Creating an explore with monthly aggregation checking if a client left by current clients


Hi Guys,

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


0 replies

Be the first to reply!

Reply