Forum Discussion
Syndicate_Admin
Administrator
AdministratorConsecutive 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...
tamerj1
Community Champion
Community ChampionSorry dventura
I got little confused. Would you please provide the expected reaults out of the same sample data?
Syndicate_AdminFor example, if I have an active client for 5 months but only 3 of those were consecutive i.e. (January, February, March, July and August) the result I expect is 3.
- tamerj1
but the provided sample data does not reflect this scenario. Please provide relevant sample data thatt reflects different possible scenarios in order to provide appropriate solution
- Syndicate_Admin
In this case I just want to calculate the active time the id 6 should throw me 3, the id 41 should throw me 3 also although since it is the longer than hard time active and so on.
idsocio Status Partner Type My Year 6 Active Benef.Familiar - Pri January 2022 6 Active February 2022 6 Active March 2022 6 Inactive Benef.Familiar - Pri April 2022 6 Active May 2022 41 Active Principa Diplomat January 2022 41 Active Benef.Familiar - Pri February 2022 41 Inactive Benef.Familiar - Pri March 2022 41 Active April 2022 41 Active Benef.Familiar - Pri May 2022 41 Active Benef.Familiar - Pri June 2022 155 Active Benef.Familiar - Pri April 2022 155 Active Benef.Familiar - Sec May 2022 248 Active Benef.Familiar - Pri April 2022 248 Inactive Benef.Familiar - Pri May 2022 301 Active Benef.Familiar - Pri April 2022 301 Active Benef.Familiar - Pri May 2022 375 Active Benef.Familiar - Sec April 2022 375 Active Benef.Familiar - Pri May 2022