Basics:
running SFDC EE version.
Have a custom formula field on the opportunity record tracking the number of days to close win since the lead created date. (LeadOpportunityAge)
I'm running a matrix report pulling in the close month date and the LeadOpportunityAge as grouped fields. Problem is, the x and y axises are only showing record count which is essentially trying to tell me how many opportunities are closing in a certain month or are a certain age.
What I need the graph to show me is for leads created in a certain month, how long is it taking them to close by plotting number of days on the x axis.
Help?
3 respuestas
I don't think the reporting engine can handle this type of report. Honestly, as much as I hate to say it, your best bet will be to export the data and do the graph in your favorite spreadsheet app.
