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

kim_barragan0126

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?

MarkSnodgrass

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.

MarkSnodgrass

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.

kim_barragan0126

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

UPPER(SQUASH_WHITESPACE(companyname))

UPPER(SQUASH_WHITESPACE(`company name`))

MarkSnodgrass

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.

kim_barragan0126

Worked great! I appreciate learning new tricks!