Introduction
Setting Up
Using OOERP
Automation
Accounts
Asset
Buying
CRM
Human Resources
E-Commerce
Loan Management
Projects
Quality Management
Selling
Stock
Support
Website
Agriculture
Education
Healthcare
Hospitality
Manufacturing
Non Profit
Customization
Integration
Regional
OneOffice Logo

Dashboard

Dashboard provides an at-a-glance view of key performance indicators relevant to the business process.

Each Dashboard consists of one or more than one Dashboard Charts each of which are configured with a data source known as Dashboard Chart Source.

To access Dashboard, go to,

Home > Customization > Dashboards > Dashboard

1. How to Create a New Dashboard

  1. Go to Dashboards List and click on New.
  2. Enter the Module Name for which you would want to see the Dashboard.
  3. Enter the Dashboard Charts that you would want to be parameterized for this Dashboard.
  4. Save.

When you click on Show Dashboard, you will be able to see the Dashboard giving the graphic representation of your transactions.

Accounting Dashboard

2. Adding Charts to Dashboard

Add charts to this dashboard by either selecting existing Dashboard Chart or creating new ones.

Adding Dashboard to Charts

Save changes and click on Show Dashboard button to see the dashboard.

Show Dashboard Button

3. Creating a New Dashboard Chart

To create a new Dashboard Chart, go to

Home > Customizations > Dashboards > Dashboard Chart > New

Provide a name for the chart, this will show up in the dashboard as the chart label, select chart type as Custom and select a Dashboard Chart Source as the data source for this chart.

Note: New Dashboard Chart Source can only be created by the Administrator User in Developer Mode.

Select Dashboard Chart Source

After setting the Chart Source field, the filters table will be shown.

Click the table to edit filters.

Dashboard Chart Filter

A modal will be shown to set filters. Click Set to set filters. Dashboard Chart Filter Modal

After setting Chart Source field, Filters table will be updated with selected filter values. Dashboard Chart Filter

In the above example, we created a custom Dashboard Chart for which we already had a Dashboard Chart Source.

You can also create basic charts like Count/Sum/Average/Group By of ToDo based on creation/modified date by selecting Count/Sum/Average/Group By as Chart Type also you can use an existing report as a source in Report Name field to create a chart by selecting Report as Chart Type.

For Count, you need to select the Doctype for which you need the chart in the Document Type field and Based On Date field in Time Series Based On.

Count Dashboard Chart

Note: If you select a child table doctype in Document Type you also have to select the parent doctype for that child table in Parent Document Type (this field will only be visible when you select child table doctype in Document Type field).

Dashboard Chart Parent Document Type

For Sum and Average you also have to select the Based On Value field in Value Based On.

Sum Dashboard Chart

For Group By you can select Group By Type as Count/Sum/Average, Group By Based On as Created By/Modified By, and Number of Groups.

Group By Dashboard Chart

4. Using Dashboards

Every chart will be shown according to the fields set in the corresponding Dashboard Chart. The result from the dashboard chart source is cached to avoid redundant queries. Since the chart data can be stale, each chart will also show the last synced time.

Dashboard Last Synced

The filters used to generate the chart data can also be changed by clicking Set Filters. The chart will be refreshed automatically according to the recently set filters.

Dashboard Filters

To get the most recent data each chart has to be refreshed forcefully by clicking Force Refresh button from the dropdown menu.