You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "AkiRyugamine (via GitHub)" <gi...@apache.org> on 2023/04/11 14:13:35 UTC
[GitHub] [superset] AkiRyugamine opened a new issue, #23647: Gaps in the Time-series area chart
AkiRyugamine opened a new issue, #23647:
URL: https://github.com/apache/superset/issues/23647
When building a Time-series area chart, there are gaps in the graph. I'm using PostgreSQL 13. The Time Grain is set to a day, so the days are plotted on the Y-axis. In the query results, it's evident that there is data (sum of numbers) for the days where there are gaps in the chart and its not null or 0. Setting Show Empty Columns is not affected the chart and have no effect
- browser type and version: in any browser
- superset version: `2.1.0`
- python version: `3.8`
- node.js version: `10.19.0`
- any feature flags active: none
--
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.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] gl commented on issue #23647: Gaps in the Time-series area chart
Posted by "gl (via GitHub)" <gi...@apache.org>.
gl commented on issue #23647:
URL: https://github.com/apache/superset/issues/23647#issuecomment-1505465489
It looks different. Here we are reporting that the values are not graphed in spite of these values being returned by the database correctly. It is not related to line extrapolation.
--
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] AkiRyugamine commented on issue #23647: Gaps in the Time-series area chart
Posted by "AkiRyugamine (via GitHub)" <gi...@apache.org>.
AkiRyugamine commented on issue #23647:
URL: https://github.com/apache/superset/issues/23647#issuecomment-1507442326
@gl I just tried it, but it seems that Superset continues to ignore any settings and changes related to the format of the displayed data and continues to round numbers, even if I add 0.001 to them. Maybe i should change something in settings or variables affecting this?
--
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] gl commented on issue #23647: Gaps in the Time-series area chart
Posted by "gl (via GitHub)" <gi...@apache.org>.
gl commented on issue #23647:
URL: https://github.com/apache/superset/issues/23647#issuecomment-1521356793
Could it be an issue with Echarts and not superset itself ? Any take on this from superset dev team ?
--
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] AkiRyugamine commented on issue #23647: Gaps in the Time-series area chart
Posted by "AkiRyugamine (via GitHub)" <gi...@apache.org>.
AkiRyugamine commented on issue #23647:
URL: https://github.com/apache/superset/issues/23647#issuecomment-1506795092
> I can simply fix it by adding 0.001 to the metric.
Please, tell about it more. How you could did it? I try to use CAST and ROUND functions, but Superset ignores it and still converting values into integer. But this functions work correctly from pgadmin, for example
--
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] AkiRyugamine commented on issue #23647: Gaps in the Time-series area chart
Posted by "AkiRyugamine (via GitHub)" <gi...@apache.org>.
AkiRyugamine commented on issue #23647:
URL: https://github.com/apache/superset/issues/23647#issuecomment-1510770061
I found temporal solution for this problem. I get SUM of needed values, round up it to integer and finally add 0.1 to them
`ROUND(SUM(column_name))+0.1`
Integers with more than 13 didgits not displayed on the chart graphic, but if it are float - it works. But I still need for permanent fix for this and the reason why it might be happening
--
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] gl commented on issue #23647: Gaps in the Time-series area chart
Posted by "gl (via GitHub)" <gi...@apache.org>.
gl commented on issue #23647:
URL: https://github.com/apache/superset/issues/23647#issuecomment-1504926971
I have a similar issue with time series line and it seems to be related to time slots when the returned value is an integer whereas other are float.
--
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
Re: [I] Gaps in the Time-series area chart [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #23647:
URL: https://github.com/apache/superset/issues/23647#issuecomment-1977263310
I'm not sure where the solution lies... is the database column an integer, or is it a float? Is this in the Chart's logic somewhere, or in core Superset's? I don't have a test case to try this out at the moment, but a PR here would be welcome if there's a clear point at which we should fix this in Superset.
--
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] sfirke commented on issue #23647: Gaps in the Time-series area chart
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on issue #23647:
URL: https://github.com/apache/superset/issues/23647#issuecomment-1505456769
Could it be related to this: https://github.com/apache/superset/issues/21093 ?
--
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] gl commented on issue #23647: Gaps in the Time-series area chart
Posted by "gl (via GitHub)" <gi...@apache.org>.
gl commented on issue #23647:
URL: https://github.com/apache/superset/issues/23647#issuecomment-1507115969
@AkiRyugamine
With a user-defined metric in the dataset:
--
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] gl commented on issue #23647: Gaps in the Time-series area chart
Posted by "gl (via GitHub)" <gi...@apache.org>.
gl commented on issue #23647:
URL: https://github.com/apache/superset/issues/23647#issuecomment-1571719255
It does look like the problem is javascript MAX_SAFE_INTEGER (2^53-1)
Shouldn't superset convert automatically integers to float when they're bigger than this limit ?
--
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