Applying HTLM to table totals

Looker Q&A Looker
,
1

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:

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

Any help would be much appreciated!

TJ