Hi Team,

I created a chart where I am tracking USD in proposals per month by their sent date, won date, and projected close date. Those dates are all fields in the proposal record. On the x axis I am using sent date. On the y axis I have a sum_if formula to aggregate the USD for sent proposals, and 2 sum_ifs couched in map_groupbys for the won and projected proposals. The chart data is correct, but I need to be able to filter by the date. When I apply the sent date filter (since the x axis is per sent date), the map_groupby formulas exclude unintended data. For example, a proposal not yet won with sent date 1 Feb 2024 and projected date 1 Apr 2024 would have its USD aggregated in the sent column in Feb and the projected column in Apr. Without a filter, this is displayed correctly by the chart. However, when I apply a the sent date filter and try to look specifically at the month of Apr the aforementioned proposal is not included in the projected column. How can I create a filter that maps those other aggregates correctly? I do not see the option to map the columns when editing the filter. The overview scroll effect helps, but I want to default the view to the past 3 and next 3 months.

Formulas

Sent: sum_if("Proposals"."Proposal Stage" != 'Draft',"Proposals"."Grand Total")

Won: map_groupby(sum_if("Proposals"."Proposal Stage" LIKE '%Closed Won%',"Proposals"."Grand Total"),"Proposals"."Proposal Sent Date","Proposals"."Proposal Closed Won Date")

Projected: map_groupby(sum_if("Proposals"."Proposal Stage" NOT LIKE '%Closed%',("Proposals"."Grand Total"*(.01*"Proposals"."Win Probability"))),"Proposals"."Proposal Sent Date","Proposals"."Estimated Close Date")