COLUMN to add as ROW.

Jez

Our database looks like this: We have separate columns for TransactionType, new_policy and renewal_policy.

So when we build the card, the New policy and Renewal Policy won't come under the Transaction type, which we want to visualize like this:

Question, How can I add/merge "new_policy_count" and "renewal_policy_count" columns under Transaction Type?

Thank you.

ColemenWilson

You can accomplish this using the Pivot Table card.

Jez

Hello coach @ColemenWilson , I want the "new_policy_count" and "renewal_policy_count" under "Transaction Type", When I'm using pivot table the "new_policy_count" and "renewal_policy_count" still goes as a column. Thank you

ColemenWilson

The best way to accomplish that would be using MagicETL. Have you used MagicETL in Domo? Or a SQL dataflow if you are more comfortable with SQL.

Jez

Hello coach @ColemenWilson — Yes, I used MagicETL-like alter columns. But I am still in the early stages. Which function in MagicETL can I use for this? Thanks