Assigning Dashboards to the Home Page

Have more questions? Submit a request

This article will teach you how to create Reports and Dashboards to give your users the best insight into your data when they need it most. We'll also illustrate the difference between Reports and Dashboards, how to create a Dashboard and edit its underlying Report. 

Dashboards are typically used to display metrics, production measurements and KPI's. The Home page can be used as a sort of "mission control" for reading your company's most valuable information. Similar to a newspaper headline, your Home page and Dashboards should tell your users what is happening in real-time at a first glance. For instance, it can tell users what stage of the deal a certain property is in, which leases are expiring, and how close your team is to reaching quarterly goals. 

 

Creating a New Dashboard

All charts and dashboards are built on Reports. 

We'll start by accessing the Reports object by navigating to the app widget and using the search bar to find reports. You might also find the Reports tab on your navigation bar if you have customized your navigation bar to contain this. 

 

Access_reports.gif

 

Sharing Settings - Reports

You can limit visibility and access of certain reports to certain users depending on their profile type, and also depending on your share settings in Report Folders. In order to add a chart to a dashboard on your users' home pages, you'll need to make sure the report that the chart is representing is accessible to those users. 

 

Screen_Shot_2019-09-25_at_10.29.49_AM.png

 

These sharing settings determine which users have access to these reports and what type of access they have, whether that be View access (read-only), Edit access (which will allow the users to modify the reports) or Manage access (which will allow the user to further share the reports to other users). 

 

Screen_Shot_2019-09-25_at_10.31.47_AM.png

 

Once in Reports, select New Report. From here you'll be asked to select the Report Type. In this example, we'll search for a report called Properties & Space/Units using the search bar. This type of report is helpful to determine what has been leased and what is vacant.

 step_5.gif

 

Customizing Your Report

Once we created this report we'll name it using the pen icon (Screen_Shot_2019-09-25_at_12.49.05_PM.png)on the top right-hand corner.

On the left-hand panel, we'll find an area to add columns. You'll want to limit the information to only the most vital for the users in your organization. For this example, we'll add the following columns:

  • Tenant
  • # Space Size (RSF)
  • # Building Occupancy (%)
  • # Lease Terms (Months)
  • Lease Commencement Date
  • Lease Expiration Date
  • # Rent (Amount)
  • Rent (Unit of Measure)

 

step3.gif

 

 You can also add filters to further specify the information you are looking to display by using the filter column on the left panel. 

Note: Quick tip for running dashboards faster (faster refresh), avoid filters like "contains", "does not equal to", or "starts with". These filters will make your report run slowly. You can instead utilize "all" and exclude parameters you do not want to include in your filter.

 

Adding Groups

On the left-hand panel, we'll find an area to Add group. This allows you to group information in your report by selected fields. This is helpful for viewing your report and helping to digest the data that is present. 

 

step_9.gif

 

Visualizing your report

once you have all your columns and filters set to your liking, click on the Add Chart button, then go into the chart configuration by clicking on the cogwheel icon (mceclip0.png) this will allow you to change your chart into a horizontal bar chart, verticle bar chart, line graph, etc. under the chart options you will also find further customization which will allow you to set up double bar graph, line graphs on top of bar graphs, and other useful customizations. Once you've configured this chart to your liking then click Save & Run.

 

2019-09-26_09-59-57__1_.gif

 

From here you click on the drop-down menu and pick Add to Dashboard. From here you will be asked to either add it to an existing dashboard or to a new dashboard. For this example, we will be adding it to our existing dashboard. Using the flexible grid of the dashboard you can customize the size of the chart and the position of its placement. Once you've settled on these details, click Save.

 2019-09-26_10-26-00__1_.gif

 

Creating Dashboards from within the Dashboard tab

Another way of creating charts is from within the dashboard tab itself. In the example below, you'll see that I have created a secondary chart to give my users insight into Average building occupancy using the "property rent roll report", utilizing the funnel graph. Depending on the report you may want to use another type of graph or illustration to convey this information.

 

2019-09-26_10-45-54__1_.gif

 

Hopefully, this article has provided a general understanding of the creation of dashboards, how reports generate these charts and various customization which are possible for these charts.

 

Adding Dashboard to the Home Page

1) From Setup, enter App Builder in the Quick Find box, then select "Lightning App Builder".
Click "New".

 

mceclip0.png

 

2) Choose where to embed the dashboard.

4) To embed a dashboard on the Home tab, find Home Page.

5) Click "Next"

 

mceclip1.png

 

6) Give your app page or home tab layout a label. Then, click "Next".

 

mceclip2.png

 

7) Choose a layout. Then, click "Finish".

 

mceclip3.png

 

8) Drag and drop the Dashboard standard component into place.

 

mceclip4.png

 

9) From the Dashboard drop-down list, choose a dashboard to embed.

 

mceclip5.png

 

10) Optionally, specify a maximum height and choose to show or hide the dashboard if an error prevents it from loading.

11) Click Save.

 

mceclip7.png

 

12) Click Activate.

 

Please reach out to Product Support (rethinkcrm@buildout.com) if you have any questions about Assigning Dashboard to Homepage. 

 

 

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful