topic Flag Customers with Two Different Statuses in App Development

Flag Customers with Two Different Statuses

LoKi_asterix — Wed, 16 Jul 2025 11:54:10 GMT

Hi all,

I'm trying to identify customers who have two or more different status values within the data, and I would appreciate guidance on how to achieve this both in the Edit Script and through an expression that can be used in a chart or table.

Thank you in advance for your support!

Tried this Sum({< Name = {'=Count( {1} Status) >1'}>} Purchase)

and

CustomerMonthlyStatusFlag:
LOAD
Number,
Month Year,
IF(COUNT(DISTINCT Status) >= 2, 1, 0) AS HasMultipleStatuses
RESIDENT YourMainTable
GROUP BY Number, Month Year;

Re: Flag Customers with Two Different Statuses

Or — Wed, 16 Jul 2025 13:16:34 GMT

I don't see anything wrong with the script code. You may want to check that the Month Year field is actually month-year and does not have an underlying date.

On the front end, assuming Number and Month Year are dimensions, you could just use the same formula as the expression, basically:

IF(COUNT(DISTINCT Status) >= 2, 1, 0)

Re: Flag Customers with Two Different Statuses

priyanka181088 — Thu, 17 Jul 2025 06:13:26 GMT

use the same script and change the set analysis as below

Sum({< HasMultipleStatuses = {1}>} Purchase)

Thanks,

Priyanka