Bucket Dimensions as a Custom Field

[jbell]

I am making a visualization of clients served by gender. We have X male clients, Y female clients, and a few trans males, trans females, and gender non-binary clients.

Because we want to preserve privacy, in the data visualization I would like to bucket any non-cis genders together.

The table currently reads:

Male: 10

Female: 4

Trans Female: 1

Trans Male: 1

Gender Non-Binary: 2

I would like it to read:

Male: 10

Female: 4

Gender Non-Binary, Trans, or Other Gender Identities: 4

I was thinking that using case would be easiest, but I don’t have permissions to edit LOOKML or SQL, so I have to do it using a calculated field. Any suggestions?

Thank you for your help!