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

gabriellegeither · May 2022

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 · May 2022

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 · May 2022

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 · June 2022

Thank you for your help, Grant.

MarkSnodgrass · June 2022

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

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

Best Answer

Answers

Categories