view: dev_eng_eimpara_fouriertable_feb_sept_22 {
      sql_table_name:DEV_ENGINEERING.EIMPARA.FOURIERTABLE_FEB_SEPT_22;;

  dimension: primary_key {
    primary_key: yes
    hidden: yes
    sql: concat(${TABLE}.activity_date,${TABLE}.isrc,${TABLE}.streams) ;;
  }


dimension_group: ACTIVITY_DATE{
  label:"Activity Date"
  type: time
  sql:${TABLE}.ACTIVITY_DATE;;
  timeframes: [year,
    quarter,
    month,
    week,
    date,
    day_of_year,
    day_of_week,
    week_of_year,
    month_name,
    month_num,
    fiscal_month_num,
    fiscal_quarter,
    fiscal_quarter_of_year,
    fiscal_year]
}
measure: STREAMS{
  label:"Streams"
  type: sum
  sql:${TABLE}.STREAMS;;
}
dimension: INFLECTION_POINT{
  label:"INFLECTION_POINT"
  type: number
  sql:${TABLE}.INFLECTION_POINT;;
}

measure: INFLECTION_POINT_MEASURE{
  label:"Inflection Point"
  type: sum
  sql:${TABLE}.INFLECTION_POINT;;
}

dimension: ISRC{
  label:"ISRC"
  type: string
  sql:${TABLE}.ISRC;;
}
dimension: FOURIER_REAL_PART{
  label:"FOURIER_REAL_PART"
  type: number
  sql:${TABLE}.FOURIER_REAL_PART;;
}
measure: FOURIER_REAL_PART_SUM {
  label: "Fourier Smoothing"
  type: sum
  sql:${TABLE}.FOURIER_REAL_PART;;
}
measure: FOURIER_REAL_PART_AVG {
  label: "Fourier Smoothing (Avg)"
  type: average
  sql:${TABLE}.FOURIER_REAL_PART;;

}
}