Is there a way we can merge the columns in DOMO table card?
Best Answer
-
I don't believe merge is available on an html table. The following shows how you can do it on a blank brick.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1
Answers
-
Not on the normal table card, you can't merge cells. The card is pretty limited on any styling. You can find more capabilities on html tables and DDX bricks.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Does HTML table have the default card properties where I can merge the cells, or we should do it via HTML code?
0 -
I don't believe merge is available on an html table. The following shows how you can do it on a blank brick.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1 -
Thanks much!
0 -
You can kind of simulate a merging if you use a Beast Mode calculation and concatenate, the big problem with it is that you loose all the cool features about number formatting, so you'll have to manually set those up. Here's an example of something I did not long ago (this inside a pivot table):
There I have a single column in the table that is displaying 3 metrics as a whole, a count, % of total and $ total, of course the beast mode to do these is not exactly the prettiest thing in the world 😅, just in case you might want to explore an alternative solution.
CONCAT('🏢:',COUNT(DISTINCT CASE WHEN Opportunity Link IS NOT NULL AND IsClosed = 'true' THEN account_id END),' (',ROUND(100*COUNT(DISTINCT CASE WHEN Opportunity Link IS NOT NULL AND IsClosed = 'true' THEN account_id END)/COUNT(DISTINCT account_id),0),'%) 💵: $',ROUND(SUM(CASE WHEN Opportunity Link IS NOT NULL AND IsClosed = 'true' THEN Incremental_Average_ARR__c ELSE 0 END)/(CASE WHEN SUM(CASE WHEN Opportunity Link IS NOT NULL AND IsClosed = 'true' THEN Incremental_Average_ARR__c ELSE 0 END) > 1000000 THEN 1000000 ELSE 1000 END),2),(CASE WHEN SUM(CASE WHEN Opportunity Link IS NOT NULL AND IsClosed = 'true' THEN Incremental_Average_ARR__c ELSE 0 END) > 1000000 THEN 'M' ELSE 'K' END))
This doesn't really merge the column headers while keeping the columns separated, which is what @ArborRose solution does great.
1 -
It makes no sense to me why Domo lacks basic formatting (merge, border, border thickness) on a table chart. Marcel's answer is so creative it hurts my brain trying to figure out how he got the heading over the three columns.
** Was this post helpful? Click Agree or Like 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
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive