How can I get the company names on a pivot table to show up on one line? One company is not.

kim_barragan0126
kim_barragan0126 Member
in Charting

I am using a pivot table to collect daily data on a sales funnel. I want to see what is in a particular stage of the funnel on a daily basis. I have one company that is showing up on two different lines, but the rest of the companies are on one line. The name is spelled correctly, so I don't understand the issue.

Any ideas?

image.png

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    My bad. SQUASH_WHITESPACE is only available in the formula tile in Magic ETL. Try this instead:

    UPPER(TRIM(`company name`))

    Make sure what is inside the ticks is your actual field name from your dataset.

    **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

    I would try troubleshooting by creating a beast mode that might help identify the issue. I would start by creating a beast mode that looks like this:

    UPPER(SQUASH_WHITESPACE(companyname))

    This will eliminate any extra spaces and convert the string to upper case as Domo is case-sensitive when evaluating differences between strings. Drag this beast mode into your rows field and remove the current one and see if things look like how they are supposed to.

    **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.
  • kim_barragan0126
    kim_barragan0126 Member

    Thank you. I am getting a calculation error. I have tried all the below.

    UPPER(SQUASH_WHITESPACE(companyname))

    UPPER(SQUASH_WHITESPACE(`company name`))

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    My bad. SQUASH_WHITESPACE is only available in the formula tile in Magic ETL. Try this instead:

    UPPER(TRIM(`company name`))

    Make sure what is inside the ticks is your actual field name from your dataset.

    **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.
  • kim_barragan0126
    kim_barragan0126 Member

    Worked great! I appreciate learning new tricks!

Categories