commit 37fb56c61ceb339079ff117971fc91bdd678db80
author alanmcruickshank <alanmcruickshank@gmail.com> Mon Jan 23 00:51:49 2017 +0000
committer Maxime Beauchemin <maximebeauchemin@gmail.com> Sun Jan 22 16:51:49 2017 -0800
tree 932935eef6216c1f15561f988eef389b05a169b1
parent 404a94cadbe44a463bda2201b22f268201a7474c

Week beginning Monday time grain for MySQL (#2014)

superset/db_engine_specs.py

diff --git a/superset/db_engine_specs.py b/superset/db_engine_specs.py
index 80cc618..8bcb1a3 100644
--- a/superset/db_engine_specs.py
+++ b/superset/db_engine_specs.py
@@ -139,6 +139,9 @@
               "+ INTERVAL QUARTER({col}) QUARTER - INTERVAL 1 QUARTER"),
         Grain("year", _('year'), "DATE(DATE_SUB({col}, "
               "INTERVAL DAYOFYEAR({col}) - 1 DAY))"),
+        Grain("week_start_monday", _('week_start_monday'),
+              "DATE(DATE_SUB({col}, "
+              "INTERVAL DAYOFWEEK(DATE_SUB({col}, INTERVAL 1 DAY)) - 1 DAY))"),
     )
 
     @classmethod