Query about setting date filters

[cmckernan93]

 

For the visual attacted, i am trying to set the filter to give the following:

 quantity of reviews recived in the last week which i have done right i think in the left hand box but

i want to compare this in the right hand box which should give the figure for the previous week (i current have a 2 week average calsulated which doesn't allow me to compare weeks acurately eonuhg)

is there some way in the filter tab to set this as sum review numbers for every week exept the current week?

Thanks, Kind Regards 

[v-stephen-msft]

Hi @cmckernan93 ,

You can try to create a year-week number column like

year-week = YEAR([Date])&"-"&WEEKNUM([Date],2)

Then create another yearweek column to sort

yearweek = YEAR([Date])*100+WEEKNUM([Date],2)

Now you can filter by week number. You can use the function of editing interaction to filter separately.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[cmckernan93]

i have tried to set an advanced filter on it here to shelp show what i'm after

but i need this date filter to update to to the next 7 day increment rather than stay static