Hello, I have one question about a formula and i hope someone more experienced can help me a bit with it. I read all topics for rolling averages and i can't find what I'm looking for.
I need to crate a formula that will check the number of feedback items received for a person for the most current week (the person's name will be selected in the filters) and if that number if below 25, the formula will calculate a metric based on the latest 25 feedback items for that person (no matter in which week they were received). If the number is 25 or more, the formula should take just those 25 items and calculate the metric based just on them.
I hope there are Qlik formula masters out there! Thanks in advance!
