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.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive