topic Reference Line - Average - After a Date in App Development

Reference Line - Average - After a Date

jerryr125 — Sun, 01 Nov 2020 09:33:25 GMT

Hi -

On a line chart I have the following reference line for the average :

=Avg(aggr(sum(QuantitySold), [SalesDate]))

How can I calculate the average after a specific sales date only, such as 10/25/2020 ?

Thoughts ? Thanks - jerry

Kushal_Chawda — Sun, 01 Nov 2020 11:31:42 GMT

@jerryr125 like below

=Avg({<[SalesDate]={">=10/25/2020"}>}aggr(sum({<[SalesDate]={">=10/25/2020"}>}QuantitySold), [SalesDate]))

jerryr125 — Mon, 02 Nov 2020 10:47:30 GMT

Excellent - Thank you very much - Jerry