Multiple values comparison with arrow

KukHwa
Participant I

Hello, 

How I can show arrows in the multiple values comparison viz?

I have table like this, 

3c943d45-d1b0-482a-a7fb-9d79f1ecb9ac.png

for the “percent change month over month column”, I would like to show the values with arrows like these.

9e33db95-2c0a-48aa-8fcb-11d9fc7c984d.png
189f5003-32d8-46ba-ad2d-b745357506ce.png

I know this is done easily in the single value comparison. Can we do the same thing for the multiple value comparison? Does anybody have a trick?

Thank you, 

0 2 3,369
2 REPLIES 2

Declan
Participant I

I don’t believe this is currently possible but I’d also love to see this feature added for Multiple Values visualizations.

CathyM
Participant I

In my use case, positive values were bad, so they’re red in the color coding below, but here are the two iterations of the colored arrow that I used:

Using LookML

You can use the html parameter in a dimension for the formatting:

  dimension: change_7_day_rolling_average {
type: number
value_format_name: percent_0
sql: (${daily_volume} * 1.0 / ${7_day_rolling_average}) - 1 ;;
html: {% if value > 0 %}
<p style="color: #990000">▲ {{ rendered_value }}</p>
{% elsif value < 0 %}
<p style="color: #009900">▼ {{ rendered_value }}</p>
{% else %}
<p style="color: #000000">{{ rendered_value }}</p>
{% endif %} ;;
}

Using Table Calculations

In the table calculations, make a field for your value and set the Formatting to “Custom...” and enter this string:

"▲  "+0%; "▼  "-0%; 0
aa2bd4a2-3c69-4891-adf5-7f8425b01919.png
Table calculation formatting

which gives you this in the Data Results: 

68b62341-1d0f-48ce-99e0-8a0a861dcc2b.png
Data column values

You can then set the conditional formatting in the visualization menu for red and green

0e344345-9866-4e2e-af79-1407f07ba409.png
Conditional formatting rules for color
Top Labels in this Space
Top Solution Authors