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?

Improve this question
3
  • Did you tried analytical snapshot ?
    – Muzammil Bajaria
    Commented 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
    – Santanu Boral
    Commented 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
    Commented Apr 7, 2017 at 18:45

1 Answer 1

Reset to default
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.

Improve this answer
3
  • Wow, this looks like it does what I want, but man, is it not simple. But, then again, is Salesforce ever?
    – bombcar
    Commented 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 ♦
    Commented 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
    Commented Apr 7, 2017 at 18:46

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .