Best way to have months show as individual columns in a table

What I am wanting to do is list the months this year Jan, Feb, March, etc.. in a table. I assumed that the date filter for a table would allow me to graph 'This year, by month' in the same way it would for a bar/line chart but that doesn't seem to be the case. Is there an easy way to do this with tools in the analyzer or would it have to be done using a beast mode?

Answers

  • I figured it out. By switching to a pivot table it then gives you more flexibility with column, values, and especially the date filter.

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷

    Pivot table is a good way to go. There is also the transpose property in the regular table that can be useful for turning your rows into columns.


    **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.