madankgit opened a new issue, #37485:
URL: https://github.com/apache/superset/issues/37485
### Bug description
When using a date column (date_value) with Time Grain set to Day and
applying time format %a (weekday abbreviation), the X-axis displays repeating
weekday labels (Mon–Sun) instead of a single ordered weekday sequence.
Each individual date is correctly treated as a unique data point; however,
the formatted axis labels repeat because %a controls display formatting only
and does not group or aggregate dates by weekday.
**Steps to Reproduce**
1. Use a dataset containing a date column (date_value) with data spanning
multiple weeks
2. Create a time-series chart
3. Configure:
- Time column: date_value
- Time Grain: Day
- X-axis time format: %a
4. Observe the X-axis labels
<img width="1531" height="422" alt="Image"
src="https://github.com/user-attachments/assets/34413b4c-1e4d-4d1f-a6e2-8661ce6b76ab";
/>
**Expected Behavior**
- X-axis should display one ordered set of weekday labels (Mon–Sun) when %a
is used
OR
- Superset should provide an option to group by weekday when formatting by
weekday name
<img width="916" height="429" alt="Image"
src="https://github.com/user-attachments/assets/11453546-1705-4e20-b0b8-792389e77383";
/>
Actual Behavior
- Weekday labels (Mon–Sun) are repeated for each week present in the dataset
- Results in duplicate and confusing X-axis labels
<img width="1531" height="422" alt="Image"
src="https://github.com/user-attachments/assets/0cd33511-9705-47d2-b6aa-ac170b545cb7";
/>
**Impact**
- Weekday-based analysis becomes unclear
- Clean visualization of weekly patterns is not possible
- Requires dataset-level workarounds using calculated columns
- Current-week or specific-week analysis is only possible via custom logic
### Screenshots/recordings
_No response_
### Superset version
master / latest-dev
### Python version
3.9
### Node version
16
### Browser
Chrome
### Additional context
_No response_
### Checklist
- [ ] I have searched Superset docs and Slack and didn't find a solution to
my problem.
- [ ] I have searched the GitHub issue tracker and didn't find a similar bug
report.
- [ ] 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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
