Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jgreen95
Contributor III
Contributor III

90 day rolling calculation

i have a list of Checks that either get a pass or fail(1/0), all of these have a week ending date attached .

How would i produce a 90 day rolling average table, so for each week ending date i have what the average pass rate was over the last 90 days?

they need to be split by a dimension as well if possible. Table table looks like below: 

 

TypeRegionOutcomeWeek
SampleEast115/03/20
SampleEast008/03/20
RoutineNorth108/03/20
Third PartySouth108/03/20
SampleWest101/03/20

 

 

0 Replies