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.
1 -
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 any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Is there a way to export the data in transposed format? The transpose property apparently works only for visualizing, not exporting. So when Domo exports, the data table is in the original non-pivoted format.
I see that using the transpose property is helpful in that it will create as many columns as there are months, whereas the Dynamic ETL requires explicitly choosing the columns, i.e. it won't automatically add a new column, for a new month, when the dataset is updated each month.0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive