Consumers who upgraded the plan within their first 2 months of joining the service in the selected period
Hi Team, I am working on a requirement, where I have fields- personID, ReportingMonth ('MMM YY'), Upgradeflag(1/0), ServicestartDate (DD-MM-YYYY), New_Client(1/0)
My requirement is to - Count the number of new consumers in the selected period (ReportingMonth) who upgraded plan in their first calendar month of service or in the next calendar month. Can use Use the consumer’s ServicestartDate to determine the first calendar month of service
Reporting Month is filter and the user can select multiple reporting months.
I am struggling to check the upgradeflag in the first or 2nd month of Service for that same person . The expression I am working on-