Forum Discussion

cmckernan93's avatar
cmckernan93
Frequent Visitor
5 years ago

Query about setting date filters

 

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 

 

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • cmckernan93's avatar
    cmckernan93
    Frequent Visitor
    5 years ago

    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

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.