Hi everyone. I'm sure I'm overlooking something easy here, but why are summary number fields/options/functionality different by the card?
For example, if you use a Progress Bar card, and you use a Beast Mode calc that has HTML/Text/Numbers in it...and it shows up in your Dimensions section it does not show up as a summary number option. Also for "show more options" here you get two boxes under "Field & Function".
But now go to a Table Card, you can put in a similar Beast Mode, and here in the "more options" you only get one box under "Field & Function".
I'm sure I'm missing some easy step here, but any help would be appreciated.
Here is the beast mode calcs for you to use or laugh at.
For the Table Card (the one that works)
concat( round(Avg(`SystemAge`),1) , ' Avg Age ' ,
case when round(max(`SystemAge`),1) > 3 then
CONCAT('<div style="color:#F73810; font-weight:bold">', round(max(`SystemAge`),1) , ' Max Age' )
else concat( round(max(`SystemAge`),1) , ' Max Age' ) end
)
For the Progress Bar (the one that doesn't work, yes there is an extra concat):
concat(
case when `%ofGoal` >= 0 and `%ofGoal` < 80 then
CONCAT('<div style="color:#F73810; font-weight:bold">', `%ofGoal`, ' % of Goal' )
when `%ofGoal` > 80 and `%ofGoal` < 100 then
CONCAT('<div style="color:#FFFF00; font-weight:bold">', `%ofGoal` , ' % of Goal' )
else
CONCAT('<div style="color:#008000; font-weight:bold">', `%ofGoal` , ' % of Goal' )
end,'')