How to configure the Intelligence dashboard in the Supplier Invoices app?

Updated on August 29, 2022 04:15AM by Admin

Apptivo Supplier Invoices App allows you to create invoices related to supplier transactions. The Apptivo Intelligence Dashboards for supplier invoices app will enable 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

  • Log in and access the Supplier Invoices App from the universal menu.
  • Click on the More(...) icon and select Settings.
SI - Settings
  • On the settings page, click on the Intelligence → Charts. Click on the Create button and select the Column Chart.
SI - CC Chart
  • You will be redirected to the Create Column chart. Enter the Name for the Chart and set the Privilege.

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

  • Enable the Toggle to display the chart in the Dashboard.
SI - Name of CC
  • 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.
  • Then, Enable the Value Restriction to set criteria for the values which are to be included in the chart.
  • Click on the Condition.
SI - CC Con
  • Here, set the Criteria on Value Restriction: Condition to include the records only if the supplier’s name is not empty.
  • Once the criteria are set, click on the Create button.
SI - CC Created
  • 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 Numeric Ranges and the Attribute is Sub Total.
  • You can set the Label Ranges for the X-Axis by clicking on the + icon and adding the Range value.
SI - X-Axis
  • Once the attribute is set for X-Axis, you can set the attribute for Y-Axis.
  • You can set the Y-axis Aggregation Type to either Sum or Count. Here, it is set as a Count.
  • In the attribute chosen as the Supplier Invoice #.
SI - Y-Axis
  • Then, click on the Filter Tab, and enable the Filter.
  • Here, the Created By attribute is selected for the Filter option.
  • Then, click on the Create button.
SI - CC 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 Supplier Invoices App.
  • On the Settings page, click on the Intelligence → Dashboards.
  • Click on the Create button to create a new dashboard.
SI - DB Create
  • You will be redirected to the Create App Dashboard page, and add the Name, and Description of the dashboard.
  • Drag and drop one column section from the Palette tab followed by the desired chart.
SI - 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.
SI - DB Created
  • The new dashboard will be created and you can view the Created Dashboard in the list.
  • Now, go to the Dashboard section in the Supplier Invoices App.
  • You can see the created dashboard - Annual Revenue of 2020.
SI - 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.
  • Click on the View Chart button as shown below.
SI - DB Filter Icon
  • You can also download the chart in CSV format by clicking on the hamburger icon.
SI - Download CSV
  • Now the downloaded chart details will be displayed in CSV format as shown below.
SI - DB Downloaded CSV