Reports - Creating Charts and Creating a Dashboard

You can create custom reports, create graphical charts, apply filters, and add them to a dashboard.

Walk-through on creating some charts to measure referrals and event sales by book date.

1. Go to Leads, and click customize report at the bottom-left.
2. In the pop-up select your columns.
3. Set the drop-down to Create New and type in a name for the report.
4. Set the grouping and sorting (this is optional and should probably be avoided in most cases)
5. Click Save, then View. The system will attempt to generate a graph automatically. You may need to click edit chart at the top to adjust it. This chart is showing how much the lead totals are grouped by referral type.
6. If we want to see the count instead of the $ amount, then we need to close the page and add Count Grouped Items to the Report Columns. Then hit Save & View again.
7. Again, hit edit chart to make sure the chart is configure correctly. FYI - the x-axis referrals to the data at the bottom of the chart and the y-axis is for the data on the left side of the chart. When using a Bar Chart you must set a Group By on the Chart settings pop-up.
8. If we want to see the referrals over time instead of just totals, we can adjust the chart as follows:
9. Another useful feature, is you can group the data on the chart by month.
10. Once it looks correct, hit add to dashboard to see it under Overview -> Charts.

Revenue Booked Over Time

Below are the settings if you want to see how much revenue is booked over time.

When on the leads screen you can filter the leads before viewing a report and it's chart, but when you are on Overview -> Charts you have to apply a saved filter to a chart when you add it to the dashboard. This could be useful if for example you want a sales chart showing several years worth of performance and you want the same chart showing only the last year of data only.

Create a new filter.

Save the filter.

Below you'll now see we have the same Event Sales chart on there, once for All leads, and once for the 90 days filter we created above.

Below, you'll see we set the Event Date Range at the top. This is a way to quickly set an additional filter to be applied. Currently it only affects the event date range, so it may not make sense to use on the reports that are using book date.

So we showed two examples on how to see referrals and event sales by book date. Additional ideas of charts you may want to see:

# of leads by create date
average revenue per event by event date
# of confirmed/complete events by create date
# of leads by customer type
average revenue by customer type

You can now specify sales reps and location (when you have access to more than one location) on preset dashboard widgets.

Is this article helpful?
2 0 3