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...
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
idsocioStatusPartner TypeDateMy
6InactiveBenef.Familiar - PriSaturday, May 30, 2022April
11Inactive Saturday, May 30, 2022April
22Inactive Saturday, May 30, 2022April
24InactiveBenef.Familiar - PriSaturday, May 30, 2022April
31Inactive Saturday, May 30, 2022April
41InactiveDiplomat PrincipaSaturday, May 30, 2022April
42InactiveBenef.Familiar - PriSaturday, May 30, 2022April
45InactiveBenef.Familiar - PriSaturday, May 30, 2022April
70Inactive Saturday, May 30, 2022April
76InactiveBenef.Familiar - PriSaturday, May 30, 2022April
104InactiveBenef.Familiar - PriSaturday, May 30, 2022April
155ActiveBenef.Familiar - PriSaturday, May 30, 2022April
222ActiveBenef.Familiar - SecSaturday, May 30, 2022April
248ActiveBenef.Familiar - PriSaturday, May 30, 2022April
287ActiveBenef.Familiar - PriSaturday, May 30, 2022April
301ActiveBenef.Familiar - PriSaturday, May 30, 2022April
316ActiveBenef.Familiar - PriSaturday, May 30, 2022April
335ActiveBenef.Familiar - SecSaturday, May 30, 2022April
375ActiveBenef.Familiar - PriSaturday, May 30, 2022April

@Syndicate_Admin