{"author_name":"Akiyah","version":"1.0","height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fakiyah.hatenablog.com%2Fentry%2F2016%2F05%2F12%2F132744\" title=\"Tableau\u306eLOOKUP\u3092\u3044\u308d\u3044\u308d\u306a\u65b9\u5411\u3067\u8a08\u7b97\u3057\u3066\u7d50\u679c\u3092\u898b\u3066\u307f\u308b - Akiyah\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","image_url":"http://cdn-ak.f.st-hatena.com/images/fotolife/A/Akiyah/20160512/20160512130704.png","provider_url":"https://hatena.blog","type":"rich","title":"Tableau\u306eLOOKUP\u3092\u3044\u308d\u3044\u308d\u306a\u65b9\u5411\u3067\u8a08\u7b97\u3057\u3066\u7d50\u679c\u3092\u898b\u3066\u307f\u308b","width":"100%","description":"Tableau\u306eLOOKUP\u304c\u3088\u304f\u308f\u304b\u3089\u306a\u304b\u3063\u305f\u306e\u3067\u3001\u3044\u308d\u3044\u308d\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\u3002 \u30c7\u30fc\u30bf\u306f\u4eca\u56de\u7528\u306b\u308f\u304b\u308a\u3084\u3059\u3044\u3088\u3046\u306a\u306e\u3092\u4f5c\u308a\u307e\u3057\u305f\u3002\u3053\u306etsv\u30d5\u30a1\u30a4\u30eb\u3092Tableau\u306b\u8aad\u307f\u8fbc\u307e\u305b\u307e\u3059\u3002 LOOKUP\u3092\u4f7f\u3063\u305f\u8a08\u7b97\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u4f5c\u308a\u307e\u3059\u3002 LOOKUP(SUM([\u6570]), FIRST()+0) LOOKUP\u3067\u5225\u306e\u3068\u3053\u308d\u306b\u5165\u3063\u3066\u3044\u308b\u5024\u3092\u53d6\u308a\u51fa\u3059\u306e\u3067\u3059\u304c\u3001FIRST()+0\u3092\u4f7f\u3063\u3066\u3044\u308b\u306e\u3067\u4e00\u756a\u5de6\u3068\u304b\u3001\u4e00\u756a\u4e0a\u3068\u304b\u3001\u3068\u306b\u304b\u304f\u63a2\u3059\u7bc4\u56f2\u306e\u4e00\u756a\u6700\u521d\u306e\u5024\u3092\u53d6\u308a\u51fa\u3057\u307e\u3059\u3002\u3053\u306e\u8a08\u7b97\u5f0f\u3092\u305f\u304f\u3055\u3093\u4e26\u3079\u3066\u3001\u300e\u6b21\u3092\u4f7f\u7528\u3057\u3066\u8a08\u7b97\u300f\u3092\u305d\u308c\u305e\u308c\u5909\u3048\u306a\u304c\u3089\u7d50\u679c\u3092\u898b\u3066\u307f\u307e\u3059\u3002\u3061\u306a\u307f\u306b\u300e\u6b21\u3092\u4f7f\u7528\u3057\u3066\u8a08\u7b97\u300f\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u306f\u300e\u8868(\u6a2a)\u300f\u3089\u3057\u3044\u3067\u3059\u2026","published":"2016-05-12 13:27:44","url":"https://akiyah.hatenablog.com/entry/2016/05/12/132744","blog_title":"Akiyah\u306e\u65e5\u8a18","categories":["Tableau"],"blog_url":"https://akiyah.hatenablog.com/","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/Akiyah/"}