sfirke opened a new issue, #23847:
URL: https://github.com/apache/superset/issues/23847
Drill to detail on a month should return all records from that month. It
returns only records from the first day.
#### How to reproduce the bug
1. Create an aggregate table chart with a datetime variable as a dimension
2. Select Time Grain = Month
3. On dashboard, Drill to Detail by Month.
### Expected results
See all results for that month (or month & other variables, if drilling by
all).
### Actual results
Only records matching the first day of the month are returned. I ran a
trace on my data warehouse and can see the SQL query is only asking for the
first day of the month:
```
SELECT TOP 50000 COUNT(*) AS [COUNT(*)]
FROM dbo.[myDataTable]
WHERE date_completed >= CONVERT(DATE, '2023-01-01', 23)
AND date_completed < CONVERT(DATE, '2023-04-27', 23)
AND date_completed = N'2023-03-01T00:00:00.000Z'
```
(The first two `date_completed` lines come from a dashboard native filter
time range).
#### Screenshots
### Environment
(please complete the following information):
- browser type and version: Firefox
- superset version: 2.1.0
--
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]
