[GitHub] [superset] EBoisseauSierra commented on issue #19157: [Aera/line chart] Zero imputation resample returns error when combined with Group By

[GitBox <gi...@apache.org>]

EBoisseauSierra commented on issue #19157:
URL: https://github.com/apache/superset/issues/19157#issuecomment-1081749636


   @zhaoyongjie thanks! I finally managed to have a go at it, and can confirm (`5ae7e5499`) that it works for `SUM` aggregation.
   
   However, my particular example uses cumulative sum, and the graphs doesn't seem to resample:
   
   ![Screenshot from 2022-03-29 12-21-38](https://user-images.githubusercontent.com/37387755/160600816-c22ad898-9c61-426b-b613-336683986741.png)
   
   (with `cumsum`, the “zero filling” would then mean horizontal line from last data point when no data for that time bucket)
   
   ----
   
   * Time
     * time grain: month
   * Query
     * metric: `SUM(metric)`
     * group by: `category`
   * AA
     * rolling function: cumsum,
     * time shift: *null*,
     * calculation type: actual values,
     * resample rule: 1 month start frequency
     * fill method: backward values.


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