Transform data from GB to TB

[Rached1996]

Hello Community , actually i'm developping a dashboard to visualise licence usage and the value in my dashboard is shown in GB 

How i can transform the results in TB ?
Thank you 

[AymanC · Accepted solution]

Hi @Rached1996,

Does the below dashboard work for you - please import it into the Looker based dashboard (which is what you're using in the attached image in your original post)

lookml:
- dashboard: gib_to_tib
  description: ""
  elements:
  - col: 0
    column_limit: 50
    conditional_formatting_include_nulls: false
    conditional_formatting_include_totals: false
    defaults_version: 1
    dynamic_fields:
    - _kind_hint: measure
      _type_hint: number
      category: table_calculation
      expression: ${ingestion_metrics.total_size_bytes_GiB} / 1024
      label: TiB
      table_calculation: tib
      value_format: null
      value_format_name: null
    enable_conditional_formatting: false
    explore: ingestion_metrics_connector
    fields:
    - ingestion_metrics.total_size_bytes_GiB
    header_font_size: 12
    header_text_alignment: left
    height: 6
    hidden_pivots: {}
    hide_row_totals: false
    hide_totals: false
    limit: 500
    limit_displayed_rows: false
    model: scn
    name: Untitled
    row: 0
    rows_font_size: 12
    show_row_numbers: true
    show_view_names: false
    size_to_fit: true
    table_theme: white
    title: Untitled
    transpose: false
    truncate_text: true
    type: looker_grid
    width: 8
  layout: newspaper
  title: Gib to TIB
metadata:
  exported_at: "2025-02-11T05:21:39-08:00"
  file_fingerprint: "898093039925564548215576731759834589006"
  looker_version: 24.18.128
  version: "1"

Kind Regards,

Ayman

[Rached1996]

Yes it works for me thanks , ill modify my file based on your dashboard code