You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "NehaAwasthi9616 (via GitHub)" <gi...@apache.org> on 2023/06/12 13:10:56 UTC
[GitHub] [superset] NehaAwasthi9616 opened a new issue, #24355: Treemap: Not showing all the data
NehaAwasthi9616 opened a new issue, #24355:
URL: https://github.com/apache/superset/issues/24355
We want to display the charges by multiple fee items in our Tree map and enable the cross-filtering. There are 5 rows in the table however treemap is only showing 3 items.
<img width="767" alt="image" src="https://github.com/apache/superset/assets/136068155/519d8a99-fbab-4d73-933f-52b833ded1c1">
### Expected results
It should show five tiles for all the rows of the table.
--
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] sfirke commented on issue #24355: Treemap: Not showing all the data
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on issue #24355:
URL: https://github.com/apache/superset/issues/24355#issuecomment-1602979849
I wonder if this is the same issue: https://github.com/apache/superset/issues/23788
--
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] Treemap: Not showing all the data [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #24355: Treemap: Not showing all the data
URL: https://github.com/apache/superset/issues/24355
--
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 #24355: Treemap: Not showing all the data
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on issue #24355:
URL: https://github.com/apache/superset/issues/24355#issuecomment-1602843447
What version of Superset are you using? I cannot replicate this on 2.1.0. Here's what I get:
--
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 #24355: Treemap: Not showing all the data
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on issue #24355:
URL: https://github.com/apache/superset/issues/24355#issuecomment-1604241508
If you try this with a dataset that has say, 10 categories instead of the 5 here, how many are shown on the treemap? If it's always two missing, then maybe it's the same as #18155.
--
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] NehaAwasthi9616 commented on issue #24355: Treemap: Not showing all the data
Posted by "NehaAwasthi9616 (via GitHub)" <gi...@apache.org>.
NehaAwasthi9616 commented on issue #24355:
URL: https://github.com/apache/superset/issues/24355#issuecomment-1604142536
Yeah, it shows all the values when changed to bar graph.
I am using postgres SQL
--
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] NehaAwasthi9616 commented on issue #24355: Treemap: Not showing all the data
Posted by "NehaAwasthi9616 (via GitHub)" <gi...@apache.org>.
NehaAwasthi9616 commented on issue #24355:
URL: https://github.com/apache/superset/issues/24355#issuecomment-1602854994
It shows this sql query which seems correct.
SELECT fee_category AS fee_category,
sum(net_amount_in_standardized_currency) AS "Charges"
FROM <table_name>
GROUP BY fee_category
ORDER BY "Charges" DESC
LIMIT 10000;
--
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] NehaAwasthi9616 commented on issue #24355: Treemap: Not showing all the data
Posted by "NehaAwasthi9616 (via GitHub)" <gi...@apache.org>.
NehaAwasthi9616 commented on issue #24355:
URL: https://github.com/apache/superset/issues/24355#issuecomment-1602888384
Even with the limit, it is giving all the five rows in the db.
Also, the table view or the result is showing the correct number of rows.
<img width="470" alt="image" src="https://github.com/apache/superset/assets/136068155/da8adbcc-e51e-4aae-a34e-48f1361aa118">
--
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 #24355: Treemap: Not showing all the data
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on issue #24355:
URL: https://github.com/apache/superset/issues/24355#issuecomment-1602904353
I am out of ideas 😕 I wonder if anyone else can replicate this or has ideas for troubleshooting it further. If you change this to another visualization type, like bar chart, do all five categories appear?
--
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 #24355: Treemap: Not showing all the data
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on issue #24355:
URL: https://github.com/apache/superset/issues/24355#issuecomment-1602869684
I wonder if the LIMIT 10000 is causing this query only to run on the first 10k records, and those two missing categories aren't present in those records? What happens if you try increasing the ROW LIMIT in the Superset chart area - or run that same query in your DB without the 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
[GitHub] [superset] sfirke commented on issue #24355: Treemap: Not showing all the data
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on issue #24355:
URL: https://github.com/apache/superset/issues/24355#issuecomment-1602849063
The tooltip with 85.64% indicates that the missing two categories aren't getting included in those calculations either. What do you get if you click ... View Query?
--
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] NehaAwasthi9616 commented on issue #24355: Treemap: Not showing all the data
Posted by "NehaAwasthi9616 (via GitHub)" <gi...@apache.org>.
NehaAwasthi9616 commented on issue #24355:
URL: https://github.com/apache/superset/issues/24355#issuecomment-1602846554
It is in 2.1.0 for me.
--
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] NehaAwasthi9616 commented on issue #24355: Treemap: Not showing all the data
Posted by "NehaAwasthi9616 (via GitHub)" <gi...@apache.org>.
NehaAwasthi9616 commented on issue #24355:
URL: https://github.com/apache/superset/issues/24355#issuecomment-1604469923
Yeah it might be, Also few of my pie charts are also showing one out of two rows.
<img width="623" alt="image" src="https://github.com/apache/superset/assets/136068155/375de9d1-12d1-43b1-b7dd-962b2ace020a">
This is pretty weird as this issue is there for a few of them. Few others are displaying the correct data.
--
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] Treemap: Not showing all the data [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #24355:
URL: https://github.com/apache/superset/issues/24355#issuecomment-1965494526
I'm not sure if this is still an issue in current versions of Superset (3.x). If it is, we can re-open this, or feel free to open a new issue with updated context and a reproducible case using example data. We're no longer supporting Superset 2.x or prior, and it's been a while since this thread saw any activity, so I'm closing this as stale.
--
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