COLUMN to add as ROW.

Jez · 2024-11-20T16:28:35+00:00

There was an error rendering this rich post.

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

Screenshot 2024-11-18 at 12.19.47 PM.png

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:

Screenshot 2024-11-18 at 12.20.31 PM.png

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

Thank you.

Find more posts tagged with

Accepted answers

All comments

ColemenWilson

You can accomplish this using the Pivot Table card.

Screenshot 2024-11-20 at 10.00.34 AM.png

Screenshot 2024-11-20 at 10.06.32 AM.png

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