Reporting on open pipeline value over time
I'd like to use the stage-history table to be able to look at how much our open pipeline of potentials was valued at at any given time in the past in order to compare it with the present. I don't see how to do this using the current table or how to join it to another table. Basically, I want to see a "snapshot" down to the level of the day of the value of the pipeline. This seems like it should be easy to do, but I can't figure out how to get a date column into the report. Stage history only reports closing date and date-modified, neither of which will work as the x axis. Any ideas for how to do this?