Table formatting
I have a table with a header that is made of up 2-3 rows and some of the cells are merged (see sample screenshot). Is this custom header possible to create in DOMO?
Best Answer
-
@AngelaO415 this is not an exact match, but as far as I'm aware it's as close as you'll be able to get using the built in Domo cards.
Key point: this relies on the data being structured in a particular format. This is detailed below.
You'll need to figure out how to aggregate and structure your dataset to be in this format.
Once you've shaped your data, you can use the built-in pivot table and apply the following settings
- Turn off total rows and total columns
- Turn off subtotal rows and subtotal columns
Then set up your table with the following mappings
You'll want to adjust the data labels like so
row_group → Subprogram
column_group → Period
dollar_value → Total $ Funded | also set as type "Currency" with 2 decimals
numeric_value → Total Relationship Length | also set as type "Number" with 0 decimals
All of this comes together to yield the following output
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**0
Answers
-
@AngelaO415 this is not an exact match, but as far as I'm aware it's as close as you'll be able to get using the built in Domo cards.
Key point: this relies on the data being structured in a particular format. This is detailed below.
You'll need to figure out how to aggregate and structure your dataset to be in this format.
Once you've shaped your data, you can use the built-in pivot table and apply the following settings
- Turn off total rows and total columns
- Turn off subtotal rows and subtotal columns
Then set up your table with the following mappings
You'll want to adjust the data labels like so
row_group → Subprogram
column_group → Period
dollar_value → Total $ Funded | also set as type "Currency" with 2 decimals
numeric_value → Total Relationship Length | also set as type "Number" with 0 decimals
All of this comes together to yield the following output
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive