Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Consecutive status count

I have a table with the status of my clients of all the months, what I would like is to be able to make a measure to calculate how many average months they last with x status, either active or inacti...
dventura's avatar
dventura
Frequent Visitor
4 years ago
idsocioEstatusTipo SocioFechaMes
6InactivoBenef.Familiar - PriSaturday, May 30, 2022April
11Inactivo Saturday, May 30, 2022April
22Inactivo Saturday, May 30, 2022April
24InactivoBenef.Familiar - PriSaturday, May 30, 2022April
31Inactivo Saturday, May 30, 2022April
41InactivoDiplomatico PrincipaSaturday, May 30, 2022April
42InactivoBenef.Familiar - PriSaturday, May 30, 2022April
45InactivoBenef.Familiar - PriSaturday, May 30, 2022April
70Inactivo Saturday, May 30, 2022April
76InactivoBenef.Familiar - PriSaturday, May 30, 2022April
104InactivoBenef.Familiar - PriSaturday, May 30, 2022April
155ActivoBenef.Familiar - PriSaturday, May 30, 2022April
222ActivoBenef.Familiar - SecSaturday, May 30, 2022April
248ActivoBenef.Familiar - PriSaturday, May 30, 2022April
287ActivoBenef.Familiar - PriSaturday, May 30, 2022April
301ActivoBenef.Familiar - PriSaturday, May 30, 2022April
316ActivoBenef.Familiar - PriSaturday, May 30, 2022April
335ActivoBenef.Familiar - SecSaturday, May 30, 2022April
375ActivoBenef.Familiar - PriSaturday, May 30, 2022April

Syndicate_Admin 

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Thank you dventura 
Sorry I have to leave now as already late afternoon over here. I will get back to you max by Monday morning.