Pivoting Help


I am having trouble using the pivot function. Attached is a Screenshot of how I am trying to arrange my data.

in the above example I am trying to take the columns AAA, BBB, and CCC and place them under a column named measure. As well as create a Compliance column to hold whether or not the measure was open or closed as well as removing the Null values.

Any help is appreciated. Thanks!

Best Answer

  • MarkSnodgrass
    Answer ✓

    You would use the Unpivot Tile and configure it like this:

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.