Unfortunately not, I can explain more precisely what am I expecting.
I have some waiters in the restaurant, they are receiving points when selling some definite group of products together.
For sure they have shifts during the week, so there will be some missing days in a calendar week for every waiter.
Sum(points)/Count(distinct cash_table_id & '|' & salescript_group_name) - this expression counts avr points for waiter taking into account data from one closed table. There're plenty of closed tables during the shift for sure.
So to compare progress of a waiter during the time I want to pick last 7 days he was working and then compare them with previous 7 days.
The output should be total average for last 7 days divided by total average for previous 7 days with some percentage result like +/- n%