Adding a combination chart to a customer service report
You can use a combination chart in many types of report. This example creates a combination chart that reports on customer case activity and adds it to a customer service report. A bar chart displays the number of cases that each user opened and a line chart displays the number of cases that each user closed for the current year.
A combination chart is also useful in a Monthly Sales Trends report to show information such as the revenue earned from sales and the number of sales that were closed in a particular period.
- Click Reports | Customer Service.
- Click New.
- Complete the fields to create a new list report. For more information, see Report Details panel fields.
You'll need a source view that compares cases opened this year against cases closed this year. For more information, see Creating a view for reports. - Ensure Report Contents includes
- Cases: case_comparitive_year
- Cases: case_comparative
- Cases: case_count_closed
- Cases: case_count_opened
- Ensure Search Criteria includes Cases: Created Data.
- Ensure Group By includes Cases: Assigned To.
- Click Continue.
- Scroll to the Chart Options panel to configure the combination chart.
For more information, see Chart Options panel fields.
- Set Chart Style to Combination.
- Set Value to Cases: case_count_opened and set Function to Sum.
- Set Category to Cases: Assigned To and set Function to Value.
- Set Line to Cases: case_count_closed and set Function to Sum.
- Set Multi-Bar to No and click Save.
- Click Save. To run the report and view the chart, click the Run icon beside your new report.