Creating new field by summing two values from existing field

afieweger

Noob here trying to not bother our internal devs…

I'm working on the chart below which is charting 3 join method values by month (noted in key below). I'd like to consolidate the Live Stream and PhoneAutomatedPin into one new value called Unassisted Entry such that the bar chart only shows Unassisted Entry and PhoneOperatorAssisted.

Thoughts on how I can tackle this?

MarkSnodgrass

Create a beast mode/calculated field that looks like this:

CASE WHEN joinmethod in ('PhoneAutomatedPin','LiveStream') THEN ‘Unassisted Entry’ ELSE joinmethod END

Drag this beast mode into your series instead of the joinmethod and the chart will do the rest.

MarkSnodgrass

No problem. Happens all the time. If you can mark any answers as accepted, that will help others in the community.

MarkSnodgrass

Create a beast mode/calculated field that looks like this:

CASE WHEN joinmethod in ('PhoneAutomatedPin','LiveStream') THEN ‘Unassisted Entry’ ELSE joinmethod END

Drag this beast mode into your series instead of the joinmethod and the chart will do the rest.

afieweger

Mark - super appreciative of your help. I'm getting a syntax error and can't figure out why.

Thoughts?

MarkSnodgrass

It doesn't like the tics around Unassisted Entry. Use the same type of single quotes you have around LiveStream and PhoneAutomatedPin on the Unassisted Entry and it should work.

afieweger

A “duh” would be appropriate. Looks great.

Thank you!

MarkSnodgrass

No problem. Happens all the time. If you can mark any answers as accepted, that will help others in the community.