7 Days Ago vs Today Report off 1 field - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Joshua OrtizJoshua Ortiz 

7 Days Ago vs Today Report off 1 field

Hi all, 

Trying to build a Report where it shows
7 days ago Field X had a value of Y
Today Fiel X has a value of Z

I have a custom Summary field and I'm not entirely sure if this is possible as it's not something I've done before. Could an Opportunity Trend Report work here?
Best Answer chosen by Joshua Ortiz
Steve MolisSteve Molis
Documentation Report on Historical Data with Reporting Snapshots 
https://help.salesforce.com/articleView?id=sf.data_about_analytic_snap.htm&type=5

All Answers

Steve MolisSteve Molis
Which Report Type are you using?  

That sort of thing is only gonna be possible with a Historical Trending Report, or a Snapshot Report
Steve MolisSteve Molis
Documentation Track Changes Over Time with Historical Trend Reporting
https://help.salesforce.com/articleView?id=sf.reports_historical_concepts.htm&type=5
Steve MolisSteve Molis
Documentation Report on Historical Data with Reporting Snapshots 
https://help.salesforce.com/articleView?id=sf.data_about_analytic_snap.htm&type=5
This was selected as the best answer
Joshua OrtizJoshua Ortiz
Thank you Steve! 

Was looking at a Trend report forgetting I had not enabled Historicals on my new instance.... #BunnySlopeFail

Adding a free beer to your tab. 
Steve MolisSteve Molis
No problem, glad you got it sorted out.  Thanks for the + Best Answer and (pending) beer

Cheers,
SteveMo