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 🙂
Any help would be much appreciated!
TJ