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 0 59
0 REPLIES 0
Top Labels in this Space
Top Solution Authors