drilldown data ordering

I'm working within the drilldown design. the default last level of the drilldown is the Dataset Table View. When i drill to that view, the columns are ordered differently than in the dataset or dataflow. is there any way to force the order of these columns in this view?
Best Answer
-
One possible option I can think of off the the top of my head is to add an additional view that is a table. Sort the columns as you would like and select the option to prevent going into that last view.
When editing the card, the table option (or heatmap) allows arranging the columns however you want and can keep certain ones omitted
editing drill path, the option to prevent the last view is on the far right of it:
0
Answers
-
One possible option I can think of off the the top of my head is to add an additional view that is a table. Sort the columns as you would like and select the option to prevent going into that last view.
When editing the card, the table option (or heatmap) allows arranging the columns however you want and can keep certain ones omitted
editing drill path, the option to prevent the last view is on the far right of it:
0 -
I had that same thought, but I like the idea of showing the 'raw' dataset in whatever form it takes. But you're right in your suggestion, I'll mark it solved. I'd still like to understand why the order is changed for this view from what's in the dataset...
0 -
I think it may have to do with whatever the previous drilldown paths are. It may be different in your case, but I notice the columns order change based on it.
For example, say I have 3 columns in a card via a file that has many columns: Event (column 3 - Y axis), Region (column 5 - the Series), and Year (column 8 - the X axis). If I drill into it to the last page where the raw data is, it has a filter for Region and Year at the top. It will default those fields to the first two columns. And even when those filters are removed, it stays that way.
That is the only possible "reason" I can think of, but somebody else may have a better idea, I am still fairly new.
0 -
I understand that the first few columns are related to the primary data on the underlying card. However, I would like to permanently move 'quantity invoiced' next to 'invoice amount'. Is it possible that the order is based on the webform used by the stacker?
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 666 Datasets
- 827 Beast Mode
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 46 Calculations & Variables
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- 122 Workflows
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 117 Community Announcements
- Automate
- 5K Archive