Magic ETL

Magic ETL

pivoting data

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:

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Best Answer

  • 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

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

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

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

  • 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

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In