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/04/04 10:17:48 UTC
[GitHub] [superset] clementchong opened a new issue, #19509: Help: How to get Pivot V2 sort by dimension?
clementchong opened a new issue, #19509:
URL: https://github.com/apache/superset/issues/19509
A clear and concise description of what the bug is.
#### How to reproduce the bug
1. Go to '...' Create Chart, Pivot V2
2. Click on '....' Select a date field into Rows. Select a metric. Try to add sort by the same date field descending.
3. Scroll down to '....'
4. See error
### Expected results
The last date I have with data is 03 Apr. I would expect to see the counts by descending TranDate.
### Actual results
The sort by field expects a metric with aggregation function. If I use custom to specify only "TranDate", I get an error on duplicate field names. I changed to "DATE(TranDate)" but output is still not sorted. The SQL generated also looks incorrect with "ORDER BY `DATE(TranDate)`"
#### Screenshots
### Environment
(please complete the following information):
- browser type and version: Chrome 99
- superset version: `superset version` 1.4.2
- python version: `python --version` 3.8.10
- node.js version: `node -v` 12.14.1
- any feature flags active: None
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [X] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [X] I have reproduced the issue with at least the latest released version of superset.
- [X] I have checked the issue tracker for the same issue and I haven't found one similar.
### Additional context
Add any other context about the problem here.
--
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
Re: [I] Help: How to get Pivot V2 sort by dimension? [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #19509:
URL: https://github.com/apache/superset/issues/19509#issuecomment-1946885869
Closing this as stale since it's been silent for so long, and we're trying to steer toward a more actionable Issues backlog. If people are still encountering this in current versions (currently 3.x) please re-open this issue, open a new Issue with updated context, or raise a PR to address the problem. 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] Help: How to get Pivot V2 sort by dimension? [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #19509: Help: How to get Pivot V2 sort by dimension?
URL: https://github.com/apache/superset/issues/19509
--
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