Question

Value Labels in graphs showing in different format

  • 9 September 2022
  • 0 replies
  • 21 views

Hello,

 

I created a value format to simplify large numbers, but i needed to use localization so i used HTML as well to be able to translate the string millions to milliard in french. Example: EN 21.16 B€, FR 21.16 Mds€

Nevertheless, when i display the values in a graphic,  it only shows the value format without the text. Example: 21.16

Here ir my lookml code:

named_value_format: eur_formatting {
  value_format: "[>=1000000000]\"\"#,##0.00,,,\" \";[>=1000000]\"\"#,##0.00,,\" \";[>=1000]\"\"#,##0.00,\" \";\"\"#,##0.00"
  strict_value_format: yes
}

  measure: commitment_m {
    label: "total_commitment"
    type: sum
    value_format_name: eur_formatting
    sql:${commitment} ;;
    html:
    {%if value >=1000000000 %}
    {{rendered_value}}{{_localization["B"]}}€
    {%elsif value >=1000000 %}
    {{rendered_value}}{{_localization["M"]}}€
    {%elsif value >=1000 %}
    {{rendered_value}}{{_localization["K"]}}€
    {% else %}
    {{rendered_value}}€
    {% endif %}
    ;;
  }


0 replies

Be the first to reply!

Reply