Hi Inclusivitie,
The first thing that I would do is to review the webinars that we have on the report designer. I would first view the webinar titled Introduction to Designing Report: Level 1 here, Introduction to Designing Report: Level 2 here, and Tips and Tricks for Designing Reports here.
After you review the above webinars, the next step would be to open up a current report, and then renaming this report and changing the elements within the properties to full fill your specific requirements.
These are the steps that I would take to create that specific line graph:
- File > Open...
- In the Report name dropdown, select the report name CRM_Home Dashboard_OppByMonth and then click on the Open button
- In order not to overrde the original report in Method, go to File > Save As
- Click on the Connect button
- In the Report name field, type in the new name for the report
- Click on the Create New Report button
To change the properties for the current bar graph, select the bar graph and left click on the little arrow at the top right hand side and click on Run Wizard...
In the Chart Type screen, select the Line type. In the Data screen, click on the Series Binding tab. In that tab, you will have a section called Value Properties and you will have to select `Count ()` in the Summary function section.
To get the number of opportunities for each month on the graph, click on Series in the wizard, and within that screen, select the Point Options tab, and in the `Value format:` dropdown select General.
I hope that this helps.
Ronen