Summary number color rule?

Greg_B · February 2018

I understand you can be powerful with the summary number in a card, referencing HTML or calculated fields/etc. Is there a way to set a color rule to it? So if i want to make the summary number RED if below 15, or GREEN if above 50, then i could make the card-size tiny and fit more cards on a page and the end user could just reference what card is RED/YELLOW and click on that card for more information. Is this possible?

jhl · February 2018

Hi Greg_B,

you might want to check out this link (especially example 3).

What you will need to do is create a beast mode with CONCAT() and put a CASE WHEN statement into the HTML color rule, so something like

CONCAT('<a style="color: ,

(CASE WHEN `Value` < 15 THEN '#f00'

WHEN > 50 THEN '#00c200'

ELSE '#ff0'

END)

,">',`Value`),'</a>')

HTH JHL

Mitch_Locher · March 2018

I use a lot of this in my summary numbers. For Example (see snippet and note, the color rules are applied to all cards: green, yellow, red - just including the 3 cards together so you can see the different colors). color example.PNG

Green
- Time Since Update < 1 hour
- Hex: #30322F
Yellow
- Time Since Update: between 1 hour and 1.66 hours
- Hex: #DBDE71
Red
- Time Since Update: > 1.66 hours
- Hex: #646763

Beast mode is very long, but essentially as follows for green.

case when datediff(minutes,NOW(),[Date]) / 60 < 1

HTML / CSS For Date | Time

then

then CONCAT(
'<b style="
padding: 2px 10px 2px 10px;
margin-right: -2px;
font-size: .69em;
text-shadow: 1px 0px 8px rgba(50, 50, 50, 0.88);
color: #ffffff;
background-color: #9FE194;
border: 1px solid #9FE194;
border-radius: 30px;">'
,CONCAT(DATE(CONVERT_TZ(MAX(`LastEnteredDateTime`),'US/Mountain','UTC'))
,' | '
,TIME_FORMAT(TIME(CONVERT_TZ(`LastEnteredDateTime`,'US/Mountain','UTC')),'%h:%i %p'))
,''
,' ' - Move Down Line Below

HTML / CSS for Time Since Update (hrs, mins)
,''

Using MOD([Column],1) Spits Out the Decimal (I.E. 10.3432 = MOD(10.3432,1) = .3432) To Get Hrs, Min
,FLOOR(MOD(ABS(((DATEDIFF(DATE(CONVERT_TZ(NOW(),'GMT','US/Mountain')),DATE(CONVERT_TZ(MAX(`LastEnteredDateTime`),'US/Mountain','UTC'))) * 86400)
+
(TIME_TO_SEC(CONVERT_TZ(NOW(),'GMT','US/Mountain')) - TIME_TO_SEC(CONVERT_TZ(MAX(`LastEnteredDateTime`),'US/Mountain','UTC'))))
/
3600),1)*60)
,' '
,'Mins.'
,''
,' '

HTML / CSS For Wording 'Since Update'
,''
,'Since Update'
,''
) -- End First Concat ('the then to the case when')

Here I would put my next when datediff(minutes,NOW(),[Date]) / 60 BETWEEN 1 and 1.66

etc. etc.

Hope this helps.

ThomasG · March 2018

Hello,

I'm having difficulty with creating this beast mode. I was looking to have a similar rule, where my summary number would be green if above a certain value, and red if below. However, I'm getting an "invalid formula" error when trying this:

CONCAT('<a style="color: ,

(CASE WHEN `Value` < 15 THEN '#f00'

WHEN > 50 THEN '#00c200'

ELSE '#ff0'

END)

,">',`Value`),'</a>')

I replaced the 'Value' portion with the dataset field I wanted, but it wasn't being picked up as an actual value (i.e. it was in red font instead of blue). I'm not sure what I'm missing, so any help would be appreciated.

Derreck · July 2018

Thomas,

Have a look. I bolded the small typo in the beast mode. the original beastmode had " vs. '.

Hope this helps.

CONCAT('<a style='color: ,

(CASE WHEN `Value` < 15 THEN '#f00'

WHEN > 50 THEN '#00c200'

ELSE '#ff0'

END)

,">',`Value`),'</a>')

Summary number color rule?

Comments

Categories