view: cm_analytics_tiktok_audience_stat  {
  sql_table_name: chartmetric.analytics.tiktok_audience_stat ;;

  dimension: account_id {
    type: string
    primary_key: yes
    sql: ${TABLE}.account_id ;;
    hidden: yes
  }

  measure: num_followers {
    type: number
    sql: ${TABLE}.num_followers;;
    hidden: yes
  }

  measure: avg_likes {
    type: number
    sql: ${TABLE}.avg_likes;;
    hidden: yes
  }

  measure: avg_comments {
    type: number
    sql: ${TABLE}.avg_comments;;
    hidden: yes
  }

  measure: avg_views {
    type: number
    sql: ${TABLE}.avg_views;;
    hidden: yes
  }

  measure: male_amount {
    label: "Male Followers"
    type: max
    sql: ${TABLE}."MALE_AMOUNT::DOUBLE";;
    value_format: "0.0%"
  }

  measure: female_amount {
    label: "Female Followers"
    type: max
    sql: ${TABLE}."FEMALE_AMOUNT::DOUBLE";;
    value_format: "0.0%"
  }

  measure: ages_13_17 {
    label: "Followers Ages 13-17"
    type: max
    sql: ${TABLE}."AGES_13_17::DOUBLE";;
    value_format: "0.0%"
  }

  measure: ages_18_24 {
    label: "Followers Ages 18-24"
    type: max
    sql: ${TABLE}."AGES_18_24::DOUBLE";;
    value_format: "0.0%"
  }

  measure: ages_25_34 {
    label: "Followers Ages 25-34"
    type: max
    sql: ${TABLE}."AGES_25_34::DOUBLE";;
    value_format: "0.0%"
  }

  measure: ages_35_44 {
    label: "Followers Ages 35-44"
    type: max
    sql: ${TABLE}.ages_35_44;;
    value_format: "0.0%"
  }

  measure: ages_45_64 {
    label: "Followers Ages 45-64"
    type: max
    sql: ${TABLE}.ages_45_64;;
    value_format: "0.0%"
  }

  measure: ages_65_ {
    label: "Followers Ages 65+"
    type: max
    sql: ${TABLE}.ages_65_;;
    value_format: "0.0%"
  }

  measure: male_ages_13_17 {
    label: "Male Followers Ages 13-17"
    type: max
    sql: ${TABLE}."MALE_13_17::DOUBLE";;
    value_format: "0.0%"
  }

  measure: female_ages_13_17 {
    label: "Female Followers Ages 13-17"
    type: max
    sql: ${TABLE}."FEMALE_13_17::DOUBLE";;
    value_format: "0.0%"
  }

  measure: male_ages_18_24 {
    label: "Male Followers Ages 18-24"
    type: max
    sql: ${TABLE}."MALE_AGES_18_24::DOUBLE";;
    value_format: "0.0%"
  }

  measure: female_ages_18_24 {
    label: "Female Followers Ages 18-24"
    type: max
    sql: ${TABLE}."FEMALE_AGES_18_24::DOUBLE";;
    value_format: "0.0%"
  }

  measure: male_ages_25_34 {
    label: "Male Followers Ages 25-34"
    type: max
    sql: ${TABLE}."MALE_AGES_25_34::DOUBLE";;
    value_format: "0.0%"
  }

  measure: female_ages_25_34 {
    label: "Female Followers Ages 25-34"
    type: max
    sql: ${TABLE}."FEMALE_AGES_25_34::DOUBLE";;
    value_format: "0.0%"
  }

  measure: male_ages_35_44 {
    label: "Male Followers Ages 35-44"
    type: max
    sql: ${TABLE}.male_ages_35_44;;
    value_format: "0.0%"
  }

  measure: female_ages_35_44 {
    label: "Female Followers Ages 35-44"
    type: max
    sql: ${TABLE}.female_ages_35_44;;
    value_format: "0.0%"
  }

  measure: male_ages_45_64 {
    label: "Male Followers Ages 45-64"
    type: max
    sql: ${TABLE}.male_ages_45_64;;
    value_format: "0.0%"
  }

  measure: female_ages_45_64 {
    label: "Female Followers Ages 45-64"
    type: max
    sql: ${TABLE}.female_ages_45_64;;
    value_format: "0.0%"
  }

  measure: male_ages_65_ {
    label: "Male Followers Ages 65+"
    type: max
    sql: ${TABLE}.male_ages_65_;;
    value_format: "0.0%"
  }

  measure: female_ages_65_ {
    label: "Female Followers Ages 65+"
    type: max
    sql: ${TABLE}.female_ages_65_;;
    value_format: "0.0%"
  }

  measure: follower_lang_en {
    label: "English Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_en;;
    value_format: "0.0%"
  }

  measure: follower_lang_es {
    label: "Spanish Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_es;;
    value_format: "0.0%"
  }

  measure: follower_lang_pt {
    label: "Portugese Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_pt;;
    value_format: "0.0%"
  }

  measure: follower_lang_de {
    label: "German Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_de;;
    value_format: "0.0%"
  }

  measure: follower_lang_ja {
    label: "Japanese Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_ja;;
    value_format: "0.0%"
  }

  measure: follower_lang_zh {
    label: "Chinese Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_zh;;
    value_format: "0.0%"
  }

  measure: follower_lang_id {
    label: "Indonesian Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_id;;
    value_format: "0.0%"
  }

  measure: follower_lang_ru {
    label: "Russian Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_ru;;
    value_format: "0.0%"
  }

  measure: follower_lang_fr {
    label: "French Speaking Followers"
    type: max
    sql: ${TABLE}.follower_lang_fr;;
    value_format: "0.0%"
  }

  dimension: follower_country_code_1 {
    label: "Follower Country 1"
    type: string
    sql: ${TABLE}."FOLLOWER_COUNTRY_CODE_1::TEXT";;
  }

  measure: follower_country_weight_1{
    label: "Follower Country 1 percentage"
    type: max
    sql: ${TABLE}.follower_country_weight_1;;
    value_format: "0.0%"
  }

  dimension: follower_country_code_2 {
    label: "Follower Country 2"
    type: string
    sql: ${TABLE}."FOLLOWER_COUNTRY_CODE_2::TEXT";;
  }

  measure: follower_country_weight_2{
    label: "Follower Country 2 percentage"
    type: max
    sql: ${TABLE}.follower_country_weight_2;;
    value_format: "0.0%"
  }

  dimension: follower_country_code_3 {
    label: "Follower Country 3"
    type: string
    sql: ${TABLE}."FOLLOWER_COUNTRY_CODE_3::TEXT";;
  }

  measure: follower_country_weight_3{
    label: "Follower Country 3 percentage"
    type: max
    sql: ${TABLE}.follower_country_weight_3;;
    value_format: "0.0%"
  }

  dimension: follower_country_code_4 {
    label: "Follower Country 4"
    type: string
    sql: ${TABLE}."FOLLOWER_COUNTRY_CODE_4::TEXT";;
  }

  measure: follower_country_weight_4{
    label: "Follower Country 4 percentage"
    type: max
    sql: ${TABLE}.follower_country_weight_4;;
    value_format: "0.0%"
  }

  dimension: follower_country_code_5 {
    label: "Follower Country 5"
    type: string
    sql: ${TABLE}."FOLLOWER_COUNTRY_CODE_5::TEXT";;
  }

  measure: follower_country_weight_5{
    label: "Follower Country 5 percentage"
    type: max
    sql: ${TABLE}.follower_country_weight_5;;
    value_format: "0.0%"
  }
}