view: int_dbt_prod_rm_db_accounting_label_country_split {
  sql_table_name: intelligence.dbt_prod_strategy.rm_db_accounting_label_country_split ;;

  dimension: period {
    view_label: "Period"
    label: "Period"
    type: string
    sql: ${TABLE}.period ;;
  }

  dimension: label_id {
    type: number
    view_label: "Label"
    label: "Label Id"
    value_format: "0"
    sql: ${TABLE}.LABEL_ID ;;
  }

  dimension: label_name {
    type: string
    view_label: "Label"
    label: "Label Name"
    sql: ${TABLE}.LABEL_NAME ;;
  }

  dimension: transaction_country_name_grouped {
    type: string
    view_label: "Transaction Country"
    label: "Transaction Country Name (Grouped)"
    sql: ${TABLE}.transaction_country_name_grouped ;;
  }

  dimension: payout_currency_code {
    type: string
    view_label: "Payout Currency"
    label: "Payout Currency Code"
    sql: ${TABLE}.PAYOUT_CURRENCY_CODE ;;
  }

  measure: prev_period_gross_revenue {
    type: sum
    view_label: "Accounting"
    label: "Gross Revenue (Previous Period)"
    value_format: "#,##0.00"
    sql: ${TABLE}.prev_period_gross_revenue ;;
  }

  measure: gross_revenue {
    type: sum
    view_label: "Accounting"
    label: "Gross Revenue"
    value_format: "#,##0.00"
    sql: ${TABLE}.GROSS_REVENUE ;;
  }

  measure: gross_revenue_with_symbol {
    type: string
    view_label: "Visualization"
    label: "Gross Revenue (Formatted)"

    sql:
      CASE
        WHEN SUM(${TABLE}.GROSS_REVENUE) >= 1000000000
          THEN CONCAT(
            TO_CHAR(SUM(${TABLE}.GROSS_REVENUE) / 1000000000.0, 'FM999,990.00'),
            'B'
          )
        WHEN SUM(${TABLE}.GROSS_REVENUE) >= 1000000
          THEN CONCAT(
            TO_CHAR(SUM(${TABLE}.GROSS_REVENUE) / 1000000.0, 'FM999,990.00'),
            'M'
          )
        WHEN SUM(${TABLE}.GROSS_REVENUE) >= 1000
          THEN CONCAT(
            TO_CHAR(SUM(${TABLE}.GROSS_REVENUE) / 1000.0, 'FM999,990.00'),
            'K'
          )
        ELSE
          TO_CHAR(SUM(${TABLE}.GROSS_REVENUE), 'FM999,990.00')
      END ;;

      html: {{ orch_app_ar_currencies.symbol_html_entity_code._value }} {{ rendered_value }} ;;
    }

  dimension: label_period_gross_revenue {
    type: number
    view_label: "Visualization"
    label: "Visualization (Label Gross Revenue)"
    value_format: "#,##0.00"
    sql: ${TABLE}.label_period_gross_revenue ;;
  }

  dimension: other_sort {
    type: number
    view_label: "Visualization"
    label: "Visualization (Sort Other)"
    sql: ${TABLE}.other_sort ;;
  }

  dimension: visualization_gross_revenue {
    type: number
    view_label: "Visualization"
    label: "Visualization (Gross Revenue)"
    value_format: "#,##0.00"
    sql: ${TABLE}.GROSS_REVENUE ;;
  }


  dimension: relationship_manager_userid {
    type: string
    view_label: "Relationship Manager"
    label: "Relationship Manager Id"
    sql: ${TABLE}.relationship_manager_userid ;;
  }

}