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