Applying HTLM to table totals

Hey Looker Devs!

Is it possible to have the HTML conditional formatting apply to the totals that are shown in a Looker table? I’ve got a sample measure working as follows however I’m unsure how to have that apply to the total:

  measure: measure {
label: "Change over period"
type: number
hidden: yes
sql: ${current} -${previous} ;;
html: {% if measure._value > 0 %}
<p><img src="https://findicons.com/files/icons/967/onebit_i/48/onebit_30.png" height=10 width=10> {{ value }}</p>
{% elsif measure._value < 0 %}
<p><img src="https://findicons.com/files/icons/573/must_have/48/stock_index_down.png" height=10 width=10> {{ value }}</p>
{% else %}
{{rendered_value}}
{% endif %}
;;

My current table is showing as follows:
 

e15a96f2-b8d4-489c-85c3-97a169a2b7db.png

Noted the above is a test - once I can get it working I’ll use pics from our own hosted bucket 🙂

Any help would be much appreciated!

TJ

0 0 103
0 REPLIES 0
Top Labels in this Space
Top Solution Authors