pivoting data

mroker
mroker Member
in Magic ETL

Hi, I have data in this format:

Date Island Count

2021-01-02 Aruba 4

2021-02-01 Curacao 9

2021-03-01 Curacao 10

I would like the data to be formatted this way:

Island 2021-01-02 2021-02-01

Aruba 4 7

Curacao 9 10

This format is for a table view

Tagged:

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    edited February 2024 Answer ✓

    You'll get the format you want with a pivot card if you set it up as shown below:

    Screenshot 2024-02-08 at 2.30.39 PM.png

    Would these results work for you? If not you can use the table card and click "transpose" in General Chart Properties but I don't think that gets you the format you are looking for:

    Screenshot 2024-02-08 at 2.27.49 PM.png

    But if so you can use the table card and click "transpose" in General Chart Properties

    Screenshot 2024-02-08 at 2.28.43 PM.png

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

Answers

  • MichelleH
    MichelleH Coach

    @mroker I'd suggest using a pivot table chart with Island in the rows, Date in the columns, and Count in the values

  • mroker
    mroker Member

    Yes, I tried this, but not getting the results that I would have hoped for.

  • MichelleH
    MichelleH Coach

    @mroker Can you please show what the results look like?

  • ColemenWilson
    ColemenWilson Coach
    edited February 2024 Answer ✓

    You'll get the format you want with a pivot card if you set it up as shown below:

    Screenshot 2024-02-08 at 2.30.39 PM.png

    Would these results work for you? If not you can use the table card and click "transpose" in General Chart Properties but I don't think that gets you the format you are looking for:

    Screenshot 2024-02-08 at 2.27.49 PM.png

    But if so you can use the table card and click "transpose" in General Chart Properties

    Screenshot 2024-02-08 at 2.28.43 PM.png

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

Categories