Creating new field by summing two values from existing field

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?

Tagged:

Best Answers

  • MarkSnodgrass
    Answer ✓

    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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • MarkSnodgrass
    Answer ✓

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

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    Answer ✓

    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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • Mark - super appreciative of your help. I'm getting a syntax error and can't figure out why.

    Thoughts?

  • 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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • A “duh” would be appropriate. Looks great.

    Thank you!

  • MarkSnodgrass
    Answer ✓

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

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.