Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Pivot Table - Wrong Sort Order #13278

Open
ValentinC-BR opened this issue Feb 22, 2021 · 0 comments
Open

Pivot Table - Wrong Sort Order #13278

ValentinC-BR opened this issue Feb 22, 2021 · 0 comments
Labels

Comments

@ValentinC-BR
Copy link

@ValentinC-BR ValentinC-BR commented Feb 22, 2021

When I create a pivot table with a dimension in "group by" section and a numeric metric, the rows are not sorted correctly.

Expected results

Rows should be sorted from the biggest number to the lowest one

Actual results

Row are sorted as if the metric is a strinc (90 > 9.0 > 80 > 8.1 > 70 etc.)

Screenshots

image

How to reproduce the bug

  1. Go to 'Chart'
  2. Click on 'Create' / Pivot Table
  3. Select a dimension in "group by"
  4. Create a metric (sum(x) for instance)
  5. Sort the metric column by clicking on the top right logo if needed

Environment

(please complete the following information):

  • superset version: 1.0.1
  • python version: 3.7.9
  • node.js version: doesn't apply, I run on Kubernetes, using gunicorn as server
  • source : Athena

Checklist

Make sure to follow these steps before submitting your issue - thank you!

  • I have checked the superset logs for python stacktraces and included it here as text if there are any.
  • I have reproduced the issue with at least the latest released version of superset.
  • I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

/

@ValentinC-BR ValentinC-BR added the #bug label Feb 22, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant