{"provider_url":"https://hatena.blog","description":"Metabase \u3092\u8a66\u3057\u3066\u3044\u305f\u3068\u3053\u308d\u3001\u4ee5\u4e0b\u306e\u70b9\u304c\u6c17\u306b\u306a\u308a\u307e\u3057\u305f\u3002 \u9031\u5358\u4f4d\u3067\u96c6\u8a08\u3059\u308b\u3068\u9031\u521d\u3081\u304c\u65e5\u66dc\u306b\u306a\u308b\uff08\u65e5\u66dc\u304b\u3089\u571f\u66dc\u307e\u3067\u306e\u96c6\u8a08\uff09 \uff08\u753b\u9762\u4f8b\uff09 DB \u7b49\u3001\u4e00\u822c\u7684\u306a\u30b7\u30b9\u30c6\u30e0\u306b\u304a\u3051\u308b\u9031\u521d\u3081\u306f\u6708\u66dc\u306b\u306a\u308b\uff08ISO 8601\uff09\u306f\u305a\u306a\u306e\u3067\u3001Metabase \u304c\u65e5\u66dc\u3078\u5909\u3048\u3066\u3044\u308b\u306e\u306f\u78ba\u5b9f\u3002 \u305d\u3053\u3067\u3001\u300cSQL\u3092\u898b\u308b\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066 SQL \u306e\u5185\u5bb9\u3092\u78ba\u8a8d\u3057\u3066\u307f\u308b\u3068\u3001\u3084\u306f\u308a\u65e5\u66dc\u3078\u5909\u3048\u308b\uff08\u9031\u521d\u3081\u306e\u6708\u66dc - 1\u65e5\uff09\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3057\u305f\u3002\uff08\u63a5\u7d9a\u5148 DB \u306f PostgreSQL\uff09 \u30af\u30a8\u30ea\u30d3\u30eb\u30c0\u30fc\u3067\u751f\u6210\u3055\u308c\u305f SQL SELECT (date_trunc('week', CAST((CAST(\"public\".\"stock_\u2026","type":"rich","version":"1.0","published":"2019-05-25 21:40:58","url":"https://fits.hatenablog.com/entry/2019/05/25/214058","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ffits.hatenablog.com%2Fentry%2F2019%2F05%2F25%2F214058\" title=\" Metabase \u306b\u304a\u3051\u308b\u9031\u521d\u3081\u306f\u65e5\u66dc - \u306a\u3093\u3068\u306a\u304f\u306a Developer \u306e\u30e1\u30e2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","height":"190","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/f/fits/20190525/20190525210517.png","author_url":"https://blog.hatena.ne.jp/fits/","title":" Metabase \u306b\u304a\u3051\u308b\u9031\u521d\u3081\u306f\u65e5\u66dc","author_name":"fits","categories":["Java","Clojure"],"provider_name":"Hatena Blog","blog_title":"\u306a\u3093\u3068\u306a\u304f\u306a Developer \u306e\u30e1\u30e2","blog_url":"https://fits.hatenablog.com/","width":"100%"}