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 2021/02/24 08:11:47 UTC
[GitHub] [superset] mikekytyzov opened a new issue #13312: Line chart series input doesnt work | Clickhouse
mikekytyzov opened a new issue #13312:
URL: https://github.com/apache/superset/issues/13312
A clear and concise description of what the bug is.
I have a metric called Total users. I want to make a line chart with this metric by day, but display only 5 top results per day.
So, i select `series` input to 5, but it doesnt work, all results still displayed. Screen is attached
### Expected results
Series is applied by each time granula.
### Actual results
Series input doesnt make any affect
#### Screenshots
#### How to reproduce the bug
1. Try create line chart with a lot of data
2. Select series to 5
3. See that series doesnt make any affect
### Environment
(please complete the following information):
- superset version: `0.34.1`
- python version: `3.6.12`
- node.js version: `node -v`
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] mikekytyzov commented on issue #13312: Line chart series input doesnt work | Clickhouse
Posted by GitBox <gi...@apache.org>.
mikekytyzov commented on issue #13312:
URL: https://github.com/apache/superset/issues/13312#issuecomment-792634036
@anilvpatel21 okay, i see. thanks for response.
btw ch already have window functions, but as experimental feature https://clickhouse.tech/docs/en/sql-reference/window-functions/
will you add a support of it ?
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] anilvpatel21 commented on issue #13312: Line chart series input doesnt work | Clickhouse
Posted by GitBox <gi...@apache.org>.
anilvpatel21 commented on issue #13312:
URL: https://github.com/apache/superset/issues/13312#issuecomment-792602134
@mikekytyzov In the above case, Sub Query is not generated when applying series limit in clickhouse db. It might be because Window function is not supported in the clickhouse.(Guess)
As a work around, you may apply actual query & create datasource with `Limit By` functionality. And then apply dummy query on the top of the datasource using visualisation (viz. of line chart).
Example: `SELECT colnames FROM tbl (clickhouse db) WHERE time_received >= toDateTime('{{ from_dttm }}')
AND time_received < toDateTime('{{ to_dttm }}') LIMIT 5 BY time_received` -- Here time_recieved is the time column. Using this as a datasource, you will achieve it.
@junlincc Its not working in v1.0.1 also.
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] junlincc commented on issue #13312: Line chart series input doesnt work | Clickhouse
Posted by GitBox <gi...@apache.org>.
junlincc commented on issue #13312:
URL: https://github.com/apache/superset/issues/13312#issuecomment-947130449
@mikekytyzov it should be working properly in the new Echart time-series line chart. if that's not the case, please file a new issue and we will attend to it in Q4
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] junlincc closed issue #13312: Line chart series input doesnt work | Clickhouse
Posted by GitBox <gi...@apache.org>.
junlincc closed issue #13312:
URL: https://github.com/apache/superset/issues/13312
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org