web_analytics:looker_studio:examples:prefecture

差分

このページの2つのバージョン間の差分を表示します。

この比較画面へのリンク

--- web_analytics:looker_studio:examples:prefecture [2023/06/21 10:48] – 作成 mikoto
+++ web_analytics:looker_studio:examples:prefecture [2023/06/21 10:50] (現在) – mikoto
@@ 行 2: / 行 2: @@
 [[:web_analytics|一つ上へ]]
+===== 都道府県自体の書き換え =====
 <code>
 CASE
@@ 行 52: / 行 53: @@
 WHEN 地域 IN ("Okinawa") THEN "沖縄県"
 ELSE "国外・判定不能"
+END
+</code>
+===== 地方への書き換え =====
+<code>
+CASE
+WHEN 地域 IN ("Hokkaido") THEN "北海道"
+WHEN 地域 IN ("Aomori", "Iwate", "Miyagi", "Akita", "Yamagata", "Fukushima") THEN "東北"
+WHEN 地域 IN ("Tokyo", "Kanagawa", "Chiba", "Saitama", "Ibaraki", "Tochigi", "Gunma") THEN "関東"
+WHEN 地域 IN ("Yamanashi", "Nagano", "Niigata", "Toyama", "Ishikawa", "Fukui") THEN "北陸・甲信越"
+WHEN 地域 IN ("Aichi", "Shizuoka", "Gifu", "Mie") THEN "東海"
+WHEN 地域 IN ("Osaka", "Hyogo", "Kyoto", "Shiga", "Nara", "Wakayama") THEN "関西"
+WHEN 地域 IN ("Okayama", "Hiroshima", "Shimane", "Tottori", "Yamaguchi", "Tokushima", "Ehime", "Kagawa", "Kochi") THEN "中・四国"
+WHEN 地域 IN ("Fukuoka", "Kumamoto", "Kagoshima", "Saga", "Nagasaki", "Oita", "Miyazaki") THEN "九州・沖縄"
+ELSE "その他"
 END
 </code>

web_analytics/looker_studio/examples/prefecture.1687312106.txt.gz · 最終更新: 2023/06/21 10:48 by mikoto