Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Question

Bug with display of euro sign in dashboard graphs

  • 10 August 2016
  • 5 replies
  • 89 views
K

Hi,


When i have a table calculation with the below formatting it is displayed correctly in the visualisation.

However when de visualisation is added to a dashboard it is not presented correctly. When i remove the euro sign it works ok.


[>=1000000]€0.0,“M”;[>=1000]€0.0,“K”;[<-1000]€0.0,“K”;€0.00

5 replies

Zam
Userlevel 4
Badge

@Kim1233 What behavior are you seeing exactly? To my understanding value_format only allows three conditions and not four.

K

The original unformatted number is presented in the dashboard graph. Also when i try with 3 conditions.

The number is formatted correctly in the table and visualisation.


[>=1000000]€0.0,“M”;[>=1000]€0.0,“K”;€0.00

sam
Rank
Userlevel 5
Badge

@Kim1233 Thank you for clarifying, and for bringing this issue to our attention! We have reproduced this behavior on our internal instances, and are discussing next steps. We’ll keep you posted on our progress!

sam
Rank
Userlevel 5
Badge

@Kim1233 In the meantime, you might try this workaround: escaping the euro symbols with double quotes makes them show up correctly in the dashboard.

[>=1000000]"€"0.0,,"M";[>=1000]"€"0.0,"K";"€"0.00

K

This fix helps, thank you for this!

Reply


Terms of Service