Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
