Average between dates in script

cdy1 — Thu, 03 Jun 2021 16:39:43 GMT

In script I need to get the average of the Total Amount of the orders from the previous 20 days from the date of the order.

Table 1:

Load

Date

Total Amount,

Date Limit AVG

Form excel file

And I need a new field that calculates the avg of past 20 days. An example is shown in the attatched excel file.

Thks.

#qlik sense

topic Average between dates in script in Search the Community