This article will step you through how to create reports and dashboards so you can give your users the best insight into their data.

A report is a great tool for capturing targeted data. When used in conjunction with a dashboard, you can easily showcase company metrics, production measurements, and KPIs in a visual way to your team.

Go even further by customizing your organization's home page with dashboards to create a "mission control" so you and your team can see what's happening in real-time. Display snapshots of your most important data - for example, open deals by deal stage, leases up for expiration, or team quarterly goal progress.

Since dashboards are built on reports, we need to start by choosing a report with the data we want to visualize.

Go to the Reports tab in your navigation bar, then click New Report.

Next, select a Report Type.

The Report Type that you choose will serve as the data source and define which objects the report will be pulling data from. Standard reports are limited to pulling data from a maximum of two different objects, so it is important to choose a report that is most applicable to the scenario.

In this example, we'll create a report to show which properties and spaces have been leased and which ones are vacant - so we'll select Properties & Space/Units as the Report Type.

Name the report by clicking the pencil icon next to the report title.

In the left pane under Add Columns, choose which fields you want included on the report. It is a best practice to only display what is most vital to your users and remove any unnecessary fields to avoid information overload. In this example, we will add the following columns:

Add filters to your report to target the data you are interested. To add a filter, click the Filters tab in the left pane and use Add Filter...

For optimal performance and faster dashboard refresh rate, avoid using filters like "contains", "does not equal to", or "starts with". These filters will make your report run slowly. Instead, use filters like "all" and exclude any unnecessary parameters.

Group your data by any field you choose. Select the field you want to group your data by in the Add group search box to the left. This is sometimes helpful for viewing reports that contain many rows of the same value.

Once you have built your report, click the Add Chart button.

Configure the chart by clicking the settings cogwheel (

)

Change the chart type to see your data in a different way - such as in horizontal bar chart, vertical bar chart, line graph, and other formats.

Customize your chart by defining attributes and other options like including a double bar graph or line graphs on top of bar graphs.

Click Save & Run when ready.

Click the drop-down menu and select Add to Dashboard. Choose whether to add to an existing dashboard or a new one. In this example, we will be adding it to an existing dashboard. Use the flexible grid to customize the size and position of any charts.

Click Save when done.

You have the ability to limit user access to certain reports based on user profile type and report folder sharing settings. In order to add a chart to a dashboard on your users' home pages, the source report must be accessible to those users.

Use the report and report folder sharing settings to determine which users can access those reports, folders, and subfolders. Choose an access level suitable for your users:

A dashboard is comprised of reports presented in a visual display to showcase key data points and trends. Dashboards are stored in folders that control who has access to them (if you have access to a folder, then you can view the dashboards within the folder). Users will also need access to the underlying reports - so system administrators may need to develop team and/or individual dashboards to ensure data is secure between teams and individuals. Dynamic dashboards allow each user to view the dashboard according to their own access level. If you are concerned about too much access to specific data, then dynamic dashboards might be the best choice.

Go to the Dashboards tab and insert a new component to an existing dashboard by clicking + Component, or create a new dashboard by clicking New Dashboard.

Select the desired report* and chart type for your new component. After adding the component, resize it, remove it or update the data source, as desired.
​* Note: you cannot choose joined reports or historical trend reports

In the example below, a secondary chart will be created in our existing dashboard to give users insight into average building occupancy using the "Property Rent Roll Report" in funnel graph format. Depending on the report, you may want to use another type of graph or illustration to convey this information.

Once you've created your dashboard, learn how to add it to the home page in this article.