Question

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

  • 14 June 2022
  • 0 replies
  • 10 views

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


This topic has been closed for comments