I have a data on a seconds level, (1 Feb 2015 12:30:13), have created a date using ceil operations ( 1.Feb 2015)
I have learned that there are previous() built in function in Qlik Sense, that would take the value of previous row (t-1)
I want to create a variable of a key figure ( for sales amount) and compare it with the average of previous months, weeks, or days.
Avg(Sales Amount(t-1)+Sales Amount(t-2)), where t might be month, or week, or a fortnight or a day.
many thanks for your help!