Help > Answers

How to configure the Intelligence dashboard in the Orders app?

Cancel

Updated on April 26, 2022 08:41AM by Admin

By using the Orders app of apptivo, you can create and store all your sales orders in one central place. The Apptivo Intelligence Dashboards for Orders app allows you to create custom dashboards to visualize and analyze your data.

To add the Intelligence Dashboard please follow these steps.

  • Create a Chart
  • Create a New Dashboard

Steps to Create Chart

  • Login and access the Orders App from the universal menu.
  • Click on the More(...) icon and select Settings.
Orders - Settings
  • On the Settings page, click on the Intelligence → Charts → App.
  • Click on the Create button and select the Column Chart.
Orders - Col Create
  • You will be redirected to the Create Column chart.
  • Enter the Name for the Chart and set the Privileges.
Orders - Name of Chart

Note: Based on the Selected Privileges of the Orders, the employee will have access to the Charts.

  • Enable the Toggle to display the chart in the Dashboard.
  • Then, you can customize the Chart.
    • Change the Title and the Sub Title of the Chart in the Title and Short Description section.
    • Background color: You can customize the background color for the chart.
    • Height: The height section enables you to alter the height of the chart.
    • Legend: Disabling, removes the legend from the chart.
Orders - Ins tab
  • Then, Enable the Value Restriction to set criteria for the values which are to be included in the chart.
  • Click on the Condition.
Orders - Con
  • Here, set the Criteria on Value Restriction: Condition to include the records only if the orders are created by the selected person.
  • Once the criteria are set, click on the Create button.
Orders - Criteria
  • In the X-Axis, you can set the Data type as Monthly, Weekly, Discrete Values, and Numeric Ranges. You can also add a label for it from the label section.
  • You can also set the X Data Attribute value. Here, the attribute is chosen as the Data Type is Time(Monthly) and the Attribute is Created On.
Orders - X Axis
  • Once the attribute is set for X-Axis, you can set the attribute for Y-Axis.
  • You can set the Aggregation Type of the Y-axis to be either Sum or Count. Here, it is set as a Sum.
  • In the attribute chosen as the Total.
Orders - Y Axis
  • Then, click on the Filter Tab, and enable the Filter.
  • Here, the Category and Sales Rep attributes are selected for the Filter option.
  • Then, click on the Create button.
Orders - Col Created
  • You can view the Created chart on the List.

Step 2: Create a Dashboard

  • Once the Column chart is created, it is mandatory to create a dashboard for the chart to reflect in the Orders App.
  • On the Settings page, click on the Intelligence → Dashboards → App.
  • Click on the Create button to create a new dashboard.
Orders - DB Create
  • You will be redirected to the Create App Dashboard page, and add the name, and description of the dashboard.
  • Using the drag and drop a section from the Palette tab followed by the desired chart.
Orders - DB Palette
  • Click on the Section Name, you will be navigated to the Inspector tab on the right side.
  • Edit the name of the section in the Inspector Tab.
  • Then, click on the Create button.
Orders - DB Ins tab
  • The new dashboard will be created and you can view the Created Dashboard in the list.
Orders - DB Lists
  • Now, go to the Dashboards section in the Orders App.
  • You can see the created dashboard - Orders Amount Chart.
Orders - Final DB
  • To filter out the records, you can click on the Filter icon and determine the status based on which the record is to be filtered.
Orders - Filter icon
  • Click on the View Chart button as shown below.
  • You can also download the chart in CSV format by clicking on the hamburger icon.
Orders - Download
  • Now the downloaded data will be shown as below.
Orders - CSV Data