Does anyone have the Beast Mode with HTML code to include an up or down arrow into a card?
I need to create a header that displays some text (users don't always click on title for descriptions) . In order to have the beast mode availalbe to select as a header, it needs to have a calclation included. I was able to get it to work by adding sum(0+0), but 0 shows up in the text. I tried using IFNULL, but then nothing shows. What is the html code to use to make sum(0+0) appear in white font which would make it "disappear"?
thanks for your thoughts!!
CONCAT('<div class="big_number_option" style="color:#525859; margin-top:-4px;
font-weight:lighter">'
,' Grey shade indicates wkly data is in future releases or N/A '
,' <br> '
,' Total row will not equal the sum of the parts due to',' <br> ' , 'mix of industry sales and growth rates vs LY '
,' <br> '
, sum(0+0)
,' <br> '
,' </div>' )
Best Answer
-
The beast mode below should help:
concat('<div style="color: green">Your text here</div>','<div style="color: white">',sum(0+0),'</div>')
This case statement will display an up or down error or nothing based on value of the revenue field.
concat(
case
when sum(`revenue`)>0 then ' ⇧ '
when sum(`revenue`)<0 then ' ⇩ '
else ''
end)
-----------------
Chris0
Answers
-
The beast mode below should help:
concat('<div style="color: green">Your text here</div>','<div style="color: white">',sum(0+0),'</div>')
This case statement will display an up or down error or nothing based on value of the revenue field.
concat(
case
when sum(`revenue`)>0 then ' ⇧ '
when sum(`revenue`)<0 then ' ⇩ '
else ''
end)
-----------------
Chris0 -
thank you!
0
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive