You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/04/05 21:05:40 UTC
[GitHub] [incubator-superset] dpugulo edited a comment on issue #9308: Time
Series Bar Chart(monthly) with 1 year time shift
dpugulo edited a comment on issue #9308: Time Series Bar Chart(monthly) with 1 year time shift
URL: https://github.com/apache/incubator-superset/issues/9308#issuecomment-609481643
same problem,
my time filter 2019-10-01 => 2020-03-31
Could it be from my mysql or language settings? or February 29 is that why?
This chart; 365 day shift
![image](https://user-images.githubusercontent.com/55461451/78509699-ba25df80-7798-11ea-89cd-b982c42594cd.png)
This chart; 1 year shift
![image](https://user-images.githubusercontent.com/55461451/78509761-1f79d080-7799-11ea-9e5c-9c58bd0ea6b9.png)
This chart; 12 month shift
![image](https://user-images.githubusercontent.com/55461451/78509801-6e276a80-7799-11ea-886b-98dc14dbe829.png)
my query;
SELECT DATE(DATE_SUB(issue_date, INTERVAL DAYOFMONTH(issue_date) - 1 DAY)) AS __timestamp,
sum(total_price) AS `Toplam`
FROM blabla
WHERE issue_date >= STR_TO_DATE('2019-10-01 00:00:00.000000', '%Y-%m-%d %H:%i:%s.%f')
AND issue_date <= STR_TO_DATE('2020-03-31 00:00:00.000000', '%Y-%m-%d %H:%i:%s.%f')
AND is_deleted = 0
AND status IN (3,
4)
GROUP BY DATE(DATE_SUB(issue_date, INTERVAL DAYOFMONTH(issue_date) - 1 DAY))
ORDER BY `Toplam` DESC
LIMIT 10000;
-----------------------------
I am waiting for your feedback and solution suggestions, thank you
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org