Hello, I haven't solved my problem after reading the related problems on the forum.
mysql version :
mysql> select version();
+-------------------------+
| version() |
+-------------------------+
| 5.7.27-0ubuntu0.16.04.1 |
+-------------------------+
1 row in set (0.04 sec)
metabase version:
v0.32.8
Log information when starting Metabase:
11-12 17:43:02 INFO metabase.core :: System timezone is 'Asia/Shanghai' ...
mysql time-zone:
mysql> show variables like '%time_zone%';
+------------------+---------------+
| Variable_name | Value |
+------------------+---------------+
| system_time_zone | CST |
| time_zone | Asia/Shanghai |
+------------------+---------------+
Some data information in MySQL table:
We can see that the date is from March 1, 2019
Some data information in Metabase:
But when I aggregate by week, we get the following information:
We can see that it started in February 2019, but the data in my MySQL started in March 2019. What are the reasons for this result? How can I get the data in metabase from March 2019