Creating new field by summing two values from existing field

Options
afieweger
afieweger Member
in Beast Mode

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?

image.png
Tagged:

Best Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    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
    MarkSnodgrass Coach
    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
    MarkSnodgrass Coach
    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.
  • afieweger
    afieweger Member

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

    Thoughts?

    image.png
  • MarkSnodgrass
    MarkSnodgrass Coach

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

    A “duh” would be appropriate. Looks great.

    Thank you!

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

Categories