[新機能]Lookerで前月比・前年比などの比較値を簡単に出せる新しいメジャータイプ「type: period_over_period」がリリースされました

explore: order_items_pop {}

view: order_items_pop {
  sql_table_name: looker-private-demo.ecomm.order_items ;;

  dimension_group: created {
    #X# group_label:"Order Date"
    label: "受注"
    type: time
    timeframes: [time, hour, date, week, month, year, hour_of_day, day_of_week, month_num, raw, week_of_year]
    sql: ${TABLE}.created_at ;;
  }

  dimension: status {
    label: "ステータス"
    type: string
    sql:
      CASE
        WHEN ${TABLE}.status = 'Processing' THEN 'プロセス中'
        WHEN ${TABLE}.status = 'Shipped' THEN '出荷'
        WHEN ${TABLE}.status = 'Complete' THEN '完了'
        WHEN ${TABLE}.status = 'Returned' THEN '返品'
        WHEN ${TABLE}.status = 'Cancelled' THEN 'キャンセル'
        ELSE null
      END ;;
  }

  dimension: sale_price {
    label: "売上"
    type: number
    value_format_name: usd
    sql: ${TABLE}.sale_price;;
  }

  measure: total_sale_price {
    label: "総売上"
    type: sum
    value_format_name: usd
    sql: ${sale_price} ;;
  }

  measure: average_sale_price {
    label: "平均売上"
    type: average
    value_format_name: usd
    sql: ${sale_price} ;;
  }

}

  measure: total_sale_price_last_year {
    label: "総売上（前年の値）"
    value_format_name: usd
    type: period_over_period
    based_on: order_items_pop.total_sale_price
    based_on_time: order_items_pop.created_year
    period: year
    kind: previous
  }

  measure: total_sale_price_last_year {
    label: "総売上（前年の値）"
    value_format_name: usd
    type: period_over_period
    based_on: order_items_pop.total_sale_price
    based_on_time: order_items_pop.created_year
    period: year
    kind: previous
  }

  measure: difference_total_sale_price_last_year {
    label: "総売上（前年との差）"
    value_format_name: usd
    type: period_over_period
    based_on: order_items_pop.total_sale_price
    based_on_time: order_items_pop.created_year
    period: year
    kind: difference
  }

  measure: changerate_total_sale_price_last_year {
    label: "総売上（前年からの変化率）"
    value_format_name: usd
    type: period_over_period
    based_on: order_items_pop.total_sale_price
    based_on_time: order_items_pop.created_year
    period: year
    kind: relative_change
  }

  measure: difference_total_sale_price_last_month {
    label: "総売上（前月との差）"
    value_format_name: usd
    type: period_over_period
    based_on: order_items_pop.total_sale_price
    based_on_time: order_items_pop.created_month
    period: month
    kind: difference
  }