How to configure the Intelligence dashboard in the Items app?

Updated on August 26, 2022 05:01AM by Admin

Apptivo Items App allows you to create your needed items, add your customers, and suppliers, and then include those items with various apps to get proceeded further with shipping and inventory management. The Apptivo Intelligence Dashboards for items 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:

  • Log in and access the Items App from the universal menu.
  • Click on the More(...) icon and select Settings.
Items - Settings
  • On the settings page, click on the Intelligence → Charts → App.
  • Click on the Create button and select the Column Chart.
Items - CC Create
  • 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 items, the employee will have access to the Charts.

  • Enable the Toggle to display the chart in the Dashboard.
Items - 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.
Items - CC Con
  • Here, set the Criteria on Value Restriction: Condition to include the records only if the item price is greater than or equal to 1000 USD.
  • Once the criteria are set, click on the Create button.
Items - CC Con 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 Discrete Values and the Attribute is Item Name.
Items - 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 Item Price.
Items - y-axis
  • Then, click on the Filter Tab, and enable the Filter.
  • Here, the Status attribute is selected for the Filter option.
  • Then, click on the Create button.
Items - 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 Items App.
  • On the Settings page, click on the Intelligence → Dashboards → App.
  • Click on the Create button to create a new dashboard.
Items - DB Create
  • You will be redirected to the Create App Dashboard page, and add the Name, and Description of the dashboard.
  • Drag and drop the one column section from the Palette tab followed by the desired chart.
Items - 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.
Items - 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 Items App.
  • You can see the created dashboard - Items worth 1K+.
Items - 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.
Items - DB Filter Icon
  • You can also download the chart in CSV format by clicking on the hamburger icon.
Items - Download CSV
  • Now the downloaded data will be shown below.
Items - Downloaded CSV