Derived Property for Custom Business Regions

Veronica Machicao

I am trying to build custom business regions by grouping users by countries in my application. Specifically, I want to group users into the following categories:

• If the Country contains "United Kingdom" or "Ireland," then group them as "UKI."
• If the Country contains "Switzerland," "Germany," or "Austria," then group them as "DACH.
• etc

I used the following formula with the help of an AI system:

<code>SWITCH(PROPERTY("country", "amplitude_user"), <br />  "United Kingdom", "UKI", <br />  "Ireland", "UKI", <br />  "Switzerland", "DACH", <br />  "Germany", "DACH", <br />  "Austria", "DACH", <br />  (none))

However, I am encountering an error when trying to save it, indicating that the formula is not valid.

Could someone please assist me in resolving this issue or suggest a corrected version of the formula?

Thank you!

BENOIT LIEVIN

Hello Veronica,

Ben here:

This is what I have done on my own organization,

It look ok on my side:


SWITCH(PROPERTY('country', 'amplitude_user'),'United Kingdom', 'UKI','Ireland', 'UKI','Switzerland', 'DACH','Germany', 'DACH','Austria', 'DACH','(none)', 'None')


Best regards,

Ben


P.S. Checkout upcoming events and user meetups on our events page.