Re: [I] Drill-to-detail on a table chart with time grain = month only returns records from the first day of month [superset]

["sfirke (via GitHub)" <gi...@apache.org>]

sfirke commented on issue #23847:
URL: https://github.com/apache/superset/issues/23847#issuecomment-2886970285

   The query for the table start begins with:
   ```
   SELECT TOP 10000 DATEADD(MONTH, DATEDIFF(MONTH, 0, date_completed), 0) AS date_completed, full_name AS full_name, sum(credit_hours) AS [Sum of Credit Hours] 
   ```
   I'm guessing it's that `DATEADD` bit - it does the grouping for the table aggregation, then unfortunately also gets passed to the drilling query. Might require a rewrite to address.


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