You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "lucapazz (via GitHub)" <gi...@apache.org> on 2026/02/11 14:05:35 UTC

[I] Time-series Table: sorting always based on first column in v6.0.0 [superset]

lucapazz opened a new issue, #37892:
URL: https://github.com/apache/superset/issues/37892

   ### Bug description
   
   ### Summary
   In Superset **6.0.0**, the **Time-series Table** visualization always sorts rows based on the **first column**, regardless of which column header is clicked.
   This prevents proper sorting on time series columns.
   
   ### Steps to Reproduce
   1. Create or open a **Time-series Table** chart.
   2. Click on the header of a **time series column** to sort it.
   4. Observe the sorting behavior.
   
   ### Expected Behavior
   - Clicking on a **time series column** should sort rows **numerically** (ascending/descending) based on that column's values.
   - Clicking on the **dimension column** (first column) should sort rows **alphabetically** based on the dimension's values.
   
   
   ### Screenshots/recordings
   
   https://github.com/user-attachments/assets/1d095b22-18bc-46ae-a73c-7aa4f9ebd538
   
   ### Superset version
   
   6.0.0
   
   ### Python version
   
   3.11
   
   ### Node version
   
   I don't know
   
   ### Browser
   
   Chrome
   
   ### Additional context
   
   _No response_
   
   ### Checklist
   
   - [x] I have searched Superset docs and Slack and didn't find a solution to my problem.
   - [x] I have searched the GitHub issue tracker and didn't find a similar bug report.
   - [x] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.


-- 
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] Time-series Table: sorting always based on first column in v6.0.0 [superset]

Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #37892:
URL: https://github.com/apache/superset/issues/37892#issuecomment-3884689654

   <!-- Greeting -->
   Hi @lucapazz! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the superset team.
   
   <!-- Answer -->
   This is a known limitation (or bug) in the Time-series Table visualization in Superset 6.0.0: the table always sorts by the first column, regardless of which column header you click. This happens because the frontend code sets the default sort to the first column and doesn't update the sort state when you click other headers. There is no dynamic sorting support for other columns in this visualization as of 6.0.0, and this isn't intentional—it's just not implemented in the current frontend logic ([source](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset-frontend/src/visualizations/TimeTable/TimeTable.jsx#L110-L339)).
   
   If you need advanced or interactive sorting, consider using the newer AG Grid Table visualization (`ag-grid-table`), which supports dynamic sorting and other features. As a workaround for the legacy Time-series Table, you can pre-sort your data before visualization, but there is no built-in fix for this sorting issue in 6.0.0.
   
   If you want to address this at the code level, the fix would involve updating the TimeTable component to manage and update the sort state based on user clicks, rather than always defaulting to the first column.
   
   
   <!-- Dosu Comment Footer -->
   *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).*
   
   ---
   <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/dedc1b96-10ff-4c65-84f1-3108363179a3?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/dedc1b96-10ff-4c65-84f1-3108363179a3?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/dedc1b96-10ff-4c65-84f1-3108363179a3?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/dedc1b96-10ff-4c65-84f1-3108363179a3?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/dedc1b96-10ff-4c65-84f1-3108363179a3?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/dedc1b96-10ff-4c65-84f1-3108363179a3?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/dedc1b96-10ff-4c65-84f1-3108363179a3?feedback_type=other)</sup>
   
   [![Chat with Dosu](https://dosu.dev/dosu-chat-badge.svg)](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github)&nbsp;[![Open in Cursor](https://dosu.dev/dosu-in-cursor.svg)](https://cursor.com/link/prompt?text=This%20is%20a%20known%20limitation%20%28or%20bug%29%20in%20the%20Time-series%20Table%20visualization%20in%20Superset%206.0.0%3A%20the%20table%20always%20sorts%20by%20the%20first%20column%2C%20regardless%20of%20which%20column%20header%20you%20click.%20This%20happens%20because%20the%20frontend%20code%20sets%20the%20default%20sort%20to%20the%20first%20column%20and%20doesn%27t%20update%20the%20sort%20state%20when%20you%20click%20other%20headers.%20There%20is%20no%20dynamic%20sorting%20support%20for%20other%20columns%20in%20this%20visualization%20as%20of%206.0.0%2C%20and%20this%20isn%27t%20intentional%E2%80%94it%27s%20just%20not%20implemented%20in%20the%20current%20frontend%20logic%20%28%5Bsource%5D%28https%3A//github.com/apache/superset/blob/829e4d92d9
 1ceae4b43b1ed3b063ffe45377799c/superset-frontend/src/visualizations/TimeTable/TimeTable.jsx%23L110-L339%29%29.%0A%0AIf%20you%20need%20advanced%20or%20interactive%20sorting%2C%20consider%20using%20the%20newer%20AG%20Grid%20Table%20visualization%20%28%60ag-grid-table%60%29%2C%20which%20supports%20dynamic%20sorting%20and%20other%20features.%20As%20a%20workaround%20for%20the%20legacy%20Time-series%20Table%2C%20you%20can%20pre-sort%20your%20data%20before%20visualization%2C%20but%20there%20is%20no%20built-in%20fix%20for%20this%20sorting%20issue%20in%206.0.0.%0A%0AIf%20you%20want%20to%20address%20this%20at%20the%20code%20level%2C%20the%20fix%20would%20involve%20updating%20the%20TimeTable%20component%20to%20manage%20and%20update%20the%20sort%20state%20based%20on%20user%20clicks%2C%20rather%20than%20always%20defaulting%20to%20the%20first%20column.)&nbsp;[![Join Discord](https://img.shields.io/badge/join-5865F2?logo=discord&logoColor=white&label=)](https://go.dosu.dev/discord-bot)&nbsp;[![Sha
 re on X](https://img.shields.io/badge/X-share-black)](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/37892)


-- 
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] Time-series Table: sorting always based on first column in v6.0.0 [superset]

Posted by "venkatamandavilli-code (via GitHub)" <gi...@apache.org>.
venkatamandavilli-code commented on issue #37892:
URL: https://github.com/apache/superset/issues/37892#issuecomment-4156815950

   Here’s a **clean, functional‑consultant style analysis** you can paste as your response to the Superset Time‑series Table sorting bug. It explains the issue clearly from a business‑functionality perspective, without going into code‑level details.
   
   ---
   
   ## **Functional Consultant Analysis**
   
   The issue stems from how the Time‑series Table visualization handles sorting behavior. Functionally, the expectation is that each column—whether it is the dimension column or any of the time‑series metric columns—should support independent sorting when the user clicks on the column header.
   
   However, in the current behavior (Superset 6.0.0), the table always sorts based on the **first column only**, regardless of which column header is clicked. This means:
   
   - Clicking on a metric column does **not** sort by that metric  
   - Sorting is always tied to the dimension column  
   - Users cannot reorder rows based on time‑series values  
   
   From a functional standpoint, this breaks a core usability requirement for analytical tables. Time‑series tables are typically used to compare metrics across periods, and sorting is essential for:
   
   - Identifying highest/lowest values  
   - Spotting trends  
   - Ranking entities  
   - Performing quick visual analysis  
   
   Because the sorting is locked to the first column, users lose the ability to perform these basic analytical tasks.
   
   ### **Impact on End Users**
   
   - Inability to sort by any metric column  
   - Incorrect interpretation of data due to fixed sorting  
   - Reduced usability for dashboards and reports  
   - Analysts must export data to external tools (Excel, Sheets) to perform sorting  
   - Time‑series table becomes less effective for comparative analysis  
   
   ### **Expected Functional Behavior**
   
   - Clicking on a metric column should sort numerically (ascending/descending)  
   - Clicking on the dimension column should sort alphabetically  
   - Sorting should update the row order dynamically based on the selected column  
   
   This is standard behavior in analytical tables across BI tools.
   
   Conclusion
   
   This is a functional defect where the sorting interaction is not being applied to the selected column. The visualization currently ignores user input and defaults to sorting only by the first column. Fixing this will restore expected analytical capabilities and significantly improve usability for time‑series analysis.
   
   


-- 
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] Time-series Table: sorting always based on first column in v6.0.0 [superset]

Posted by "achyuth8055 (via GitHub)" <gi...@apache.org>.
achyuth8055 commented on issue #37892:
URL: https://github.com/apache/superset/issues/37892#issuecomment-4015774634

   Hi @rusackas I see this issue is still open and you've welcomed new PRs. I am a student preparing for GSoC and I'm very interested in helping resolve this sorting behaviour in the Time-series Table.
   
   I've noticed there is an existing PR #38094. Is the team looking for a fresh approach, or should I try to build upon/fix the remaining issues in that PR? I'm setting up my local environment now to investigate.


-- 
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] Time-series Table: sorting always based on first column in v6.0.0 [superset]

Posted by "johnquevedo (via GitHub)" <gi...@apache.org>.
johnquevedo commented on issue #37892:
URL: https://github.com/apache/superset/issues/37892#issuecomment-4579822104

   Hi! I’m interested in working on this issue. I’m going to try reproducing it locally and investigate a fix. I’ll follow up if I’m able to confirm the cause or open a PR.


-- 
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] Time-series Table: sorting always based on first column in v6.0.0 [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #37892: Time-series Table: sorting always based on first column in v6.0.0
URL: https://github.com/apache/superset/issues/37892


-- 
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] Time-series Table: sorting always based on first column in v6.0.0 [superset]

Posted by "Nareshkumar2583 (via GitHub)" <gi...@apache.org>.
Nareshkumar2583 commented on issue #37892:
URL: https://github.com/apache/superset/issues/37892#issuecomment-4107841587

   Hi, I’m interested in contributing to this issue. 
   I would like to work on fixing the sorting behavior in the Time-series Table. 
   Please let me know if I can proceed and if there are any suggestions.


-- 
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] Time-series Table: sorting always based on first column in v6.0.0 [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #37892:
URL: https://github.com/apache/superset/issues/37892#issuecomment-3986064915

   PR Welcome if you feel like diving into it.


-- 
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] Time-series Table: sorting always based on first column in v6.0.0 [superset]

Posted by "nireknj (via GitHub)" <gi...@apache.org>.
nireknj commented on issue #37892:
URL: https://github.com/apache/superset/issues/37892#issuecomment-4115720010

   Hi, I’d like to work on this issue.
   
   I’ve reviewed the bug description and understand that the Time-series Table visualization is currently always sorting based on the first column, instead of dynamically sorting based on the selected column header.
   
   ### My plan is to:
   
   Reproduce the issue locally on Superset 6.0.0
   Trace the sorting logic in the Time-series Table component
   Update the sorting behavior to respect the selected column (both dimension and time-series columns)
   Ensure correct numeric vs alphabetical sorting based on column type
   
   Please let me know if anyone is already working on this, or if you have any guidance before I proceed.
   
   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] Time-series Table: sorting always based on first column in v6.0.0 [superset]

Posted by "DeeWooo (via GitHub)" <gi...@apache.org>.
DeeWooo commented on issue #37892:
URL: https://github.com/apache/superset/issues/37892#issuecomment-4509783547

    I'd like to work on this


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