COLUMN to add as ROW.

Jez
Jez Member
in Magic ETL

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.

Answers

  • ColemenWilson
    ColemenWilson Coach
    edited November 2024

    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

    If I solved your problem, please select "yes" above

  • Jez
    Jez Member

    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
    ColemenWilson Coach
    edited November 2024

    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.

    If I solved your problem, please select "yes" above

  • Jez
    Jez Member

    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

Categories