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/07/23 23:48:36 UTC

[GitHub] [superset] matthewphua opened a new issue #15883: Sort By in Pivot Table

matthewphua opened a new issue #15883:
URL: https://github.com/apache/superset/issues/15883


   Sort by field in pivot table does not work.
   ### Expected results
   
   Enter a metric/custom sql for the pivot table to sort its entries. 
   
   ### Actual results
   
   The sort by field is not implemented into the pivot table chart but it is visible in underlying query
   
   
   #### Screenshots
   Pivot table not sorted by max(rank) 
   <img width="688" alt="Screen Shot 2021-07-23 at 4 45 33 PM" src="https://user-images.githubusercontent.com/85198947/126850677-8ea90447-fa7e-4e4b-8ea3-a05abc8d6826.png">
   
   Visible in query
   <img width="472" alt="Screen Shot 2021-07-23 at 4 47 54 PM" src="https://user-images.githubusercontent.com/85198947/126850776-1a54238f-5de7-4fc4-8b54-06ab64541c50.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] junlincc commented on issue #15883: Sort By in Pivot Table

Posted by GitBox <gi...@apache.org>.
junlincc commented on issue #15883:
URL: https://github.com/apache/superset/issues/15883#issuecomment-887077991


   Pivot v1 and Table has different behavior on sort by metric(when it's different than the metric) .. anyway, for V2 we should at least show the data in the south 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

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 #15883: Sort By in Pivot Table

Posted by GitBox <gi...@apache.org>.
junlincc commented on issue #15883:
URL: https://github.com/apache/superset/issues/15883#issuecomment-885968829


   so... there's a sortby metric added to the south table/data, it's just not impacting the pivot table itself....
   it seems to be a simple fix BUT we are not fixing it. pivot v2 doesn't support sort by metric yet, and it should. 
   @kgabryje see if we can reach feature parity by mid august. 


-- 
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] zhaoyongjie closed issue #15883: Sort By in Pivot Table

Posted by GitBox <gi...@apache.org>.
zhaoyongjie closed issue #15883:
URL: https://github.com/apache/superset/issues/15883


   


-- 
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] kgabryje commented on issue #15883: Sort By in Pivot Table

Posted by GitBox <gi...@apache.org>.
kgabryje commented on issue #15883:
URL: https://github.com/apache/superset/issues/15883#issuecomment-886702284


   @matthewphua @junlincc Sort by in pivot table v1 seems to be working though
   
   https://user-images.githubusercontent.com/15073128/126996248-4cd71144-38ab-4a13-8e26-52dcf026d1ee.mov
   
   Anyway, implemented in v2 as well
   https://github.com/apache-superset/superset-ui/pull/1240
   


-- 
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] kgabryje edited a comment on issue #15883: Sort By in Pivot Table

Posted by GitBox <gi...@apache.org>.
kgabryje edited a comment on issue #15883:
URL: https://github.com/apache/superset/issues/15883#issuecomment-886702284


   @matthewphua @junlincc Sort by in pivot table v1 seems to be working though
   
   https://user-images.githubusercontent.com/15073128/126996248-4cd71144-38ab-4a13-8e26-52dcf026d1ee.mov
   
   Anyway, implemented in v2 as well. The behaviour is the same as in Table chart
   https://github.com/apache-superset/superset-ui/pull/1240
   


-- 
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