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 2022/05/16 11:03:41 UTC
[GitHub] [superset] RavazziniAndrea opened a new issue, #20076: Pivot Table v2, can't show subtotals based on a single column
RavazziniAndrea opened a new issue, #20076:
URL: https://github.com/apache/superset/issues/20076
In the example shown in the picture, I'm extracting prices (column 'Importo') and a delta %. When showing subtotals, I need the sum of prices, but when selecting SUM as aggregate function, it calculates even the sum of the delta, that doesn't make sense.
Is it possible to aggregate on a single column? Even leaving other values empty and showing only the one associated to the aggregate function
#### Screenshots
--
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] rusackas commented on issue #20076: Pivot Table v2, can't show subtotals based on a single column
Posted by GitBox <gi...@apache.org>.
rusackas commented on issue #20076:
URL: https://github.com/apache/superset/issues/20076#issuecomment-1130125947
Trying to make sure I understand the issue/request. It looks like the subtotals are indeed summing/aggregating the values correctly. However, while it's GOOD that you're getting a SUM of the pricing, it's BAD that you're getting a SUM of the delta, and you'd... rather not show that aggregation? Trying to get a sense of what you DO expect to see in that red box, and how you would expect the plugin/controls to support that.
--
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] moksh-enf commented on issue #20076: Pivot Table v2, can't show subtotals based on a single column
Posted by GitBox <gi...@apache.org>.
moksh-enf commented on issue #20076:
URL: https://github.com/apache/superset/issues/20076#issuecomment-1199942012
Even I would like to have this feature 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
Re: [I] Pivot Table v2, can't show subtotals based on a single column [superset]
Posted by "AdalvP (via GitHub)" <gi...@apache.org>.
AdalvP commented on issue #20076:
URL: https://github.com/apache/superset/issues/20076#issuecomment-1809713954
I support this issue. The same problem - I don't need total sum where there is % sign in metric column and there isn't possibility to cancel total sum for specific columns. However, for column as shipment or plan (without % sign) it's ok to sum each month result for annual total.
Addition: is it possible to bold pivot table borders? maybe is there issue on this topic?
Thanks
--
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] Pivot Table v2, can't show subtotals based on a single column [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #20076: Pivot Table v2, can't show subtotals based on a single column
URL: https://github.com/apache/superset/issues/20076
--
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] rusackas commented on issue #20076: Pivot Table v2, can't show subtotals based on a single column
Posted by GitBox <gi...@apache.org>.
rusackas commented on issue #20076:
URL: https://github.com/apache/superset/issues/20076#issuecomment-1132179998
Hmmm... to do what you ask here would mean either building a dynamic control panel section with display options for each metric you've added (kind of like the "Customize Columns section of the Table controls, pictured below), or additional (chart-specific) options for each item in the Metrics control. I don't think we have plans to do either right now, bur if you're passionate about this, you might want to look at how the Table controls are built and consider opening a PR based on that if you're interested in contributing to the codebase.
<img width="792" alt="image" src="https://user-images.githubusercontent.com/812905/169399582-885e0162-1304-4d27-87e3-c89c9bba6313.png">
--
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] RavazziniAndrea commented on issue #20076: Pivot Table v2, can't show subtotals based on a single column
Posted by GitBox <gi...@apache.org>.
RavazziniAndrea commented on issue #20076:
URL: https://github.com/apache/superset/issues/20076#issuecomment-1130215467
Yes, it's how you said. The sum of pricing is good and the sum of the delta doesn't make sense..
In my opinion, if there was the possibility to aggregate on a single set of column (in this case the sum of pricing), the other columns in the subtotal can even be left empty.
In my case specifically, the red box can be left empty because the value that I have to see in the subtotal is the sum of prices.
Thanks for the response!
--
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] Pivot Table v2, can't show subtotals based on a single column [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #20076:
URL: https://github.com/apache/superset/issues/20076#issuecomment-2043490817
This issue has been quiet for quite a while, so I'll close it in favor of https://github.com/apache/superset/issues/23560, which links to the other similar reported issues. This thread still has a lot of useful context, so thank you for reporting it here and I hope it serves in helping someone tackle the problem. To say what everyone says in open source, contributions welcome/encouraged!
--
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