2

We want to add to a dashboard a graph showing how many contacts are in a report over time. So in May there were 12,000, in June 13,000, in Aug 12,500.

I can create the report that shows how many contacts today but I don't see a way of getting the historical data. Would I have to create a report for each month? How could I sum them into a single graph for display on a dashboard?

3
  • Did you tried analytical snapshot ? Apr 7, 2017 at 14:44
  • do you want to plot the data based on createddate of the contact? like those created date falls on Mar, it will be counted in March and total contact count will show all the sum till March Apr 7, 2017 at 14:46
  • Yeah, basically want to track how we're doing in getting new contacts/leads over time as an organization
    – bombcar
    Apr 7, 2017 at 18:45

1 Answer 1

4

Unless you've been storing this historical data, there's no way to get this report. You can start from today by using an analytical snapshot, outlined in Report on Historical Data with Reporting Snapshots. Basically, create a custom object with the fields for data you want to store, build a report that shows the data you want to be able to show over time, then schedule the analytic snapshot to occur on a frequency. You will then be able to report on historical data.

3
  • Wow, this looks like it does what I want, but man, is it not simple. But, then again, is Salesforce ever?
    – bombcar
    Apr 7, 2017 at 14:52
  • 1
    @bombcar It only looks complicated. It really only takes a few minutes to set up, and is fully automated afterwards.
    – sfdcfox
    Apr 7, 2017 at 15:43
  • I'll have to trust you on that, all salesforce docs make things look like they require an Act of God to implement.
    – bombcar
    Apr 7, 2017 at 18:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.