Forum Discussion

yannick90's avatar
yannick90
Frequent Visitor
4 years ago
Solved

Auto select previous date

Hello guys, I'm coming up to you with an issue that has been frying my brain lately. Long story short, right now I'm comparing the data of two dates (this week vs previous week) hence on my calendar...
Need Help
  • yannick90's avatar
    yannick90
    4 years ago

    hi danextian ,

     

    Thanks for all the support. The user decided to go with a different approach instead. 

yannick90's avatar
yannick90
Frequent Visitor
4 years ago

Hi danextian, 

Here is a sample of my date tables:

main calendar

additional columns:

 

if I select May 1st and April 24th, below is the result:

 

but I want to get the same result just by selecting May 1st

  • danextian's avatar
    danextian
    Super User
    4 years ago

    Are you trying to compute for the value in the last 7 days a week ago or the value 7 days ago?

    • yannick90's avatar
      yannick90
      Frequent Visitor
      4 years ago

      Hello danextian,

       

      I'm a bit confused by your statement. let me give a bit of context, the file is updated every monday. For example it was updated on April 24th, then May 1st and so on. So the scenario goes like this (take the data of "this week which is May 1st" and compare it to the data of last week which is April 24th

       

      There is already a formula in place that is giving me the value of this week (2,8 millions) and last week (2,9 millions). 

      Now the objective is to get the value of difference and variation by just selecting this week's date rather than selecting this week and last week

       

      Let me know if it answers your question

      Thanks  

      • danextian's avatar
        danextian
        Super User
        4 years ago

        What i was trying to say was, if today is Jan 30, are you trying to compare Jan 30 with Jan 23 or the from Jan 23 to 30 vs Jan 16 to Jan 22?