How do I change the data from being horizontal to vertical using a calculated field?

gabriellegeither

My data is currently horizontal so each column has a different month with the totals below (example below). I would like the data to be vertical so that it is easier to display the data visually within domo. I have placed an example below. I am not sure how to make a calculated field to display the date and totals vertically in one column instead of horizontally across many columns. Any help is much appreciated!

GrantSmith

Hi @gabriellegeither

It's a bit difficult to do this with a beast mode. I'd recommend utilizing an ETL and the Dynamic UnPivot tile to transpose your data. You can read on these here: https://domohelp.domo.com/hc/en-us/articles/360044951294-New-Magic-ETL-Tiles-Pivot#4.

GrantSmith

Hi @gabriellegeither

It's a bit difficult to do this with a beast mode. I'd recommend utilizing an ETL and the Dynamic UnPivot tile to transpose your data. You can read on these here: https://domohelp.domo.com/hc/en-us/articles/360044951294-New-Magic-ETL-Tiles-Pivot#4.

gabriellegeither

Thank you for your help, Grant.

MarkSnodgrass

You might try using the Transpose option in the General Chart Properties.