Skip to Content

How to create a basic bar chart in Jitterbit App Builder

In this example we will use the Northwinds database to create a Bar chart that displays the total orders for each employee. In order for a Bar Chart to display properly it requires at least 2 Controls be defined, one for the Category and one for the Value. Additional Controls may be defined if you are specifying Color, Sort, Flag, or JSON Options Object.

How to configure

  1. Create a Business Object that targets the OrderDetail table
  2. Add the Order table, and join it with the OrderDetail table using an Inner Join, using OrderID as the Join Columns
  3. Add the EmployeeID column from the Order table
  4. Add an Expression using the Sum function to find the total Orders for each employee. For example: SUM(O.Quantity*O.UnitPrice*(1-O.Discount))
  5. Set the Logical Data Type to Currency
  6. Create a Page with a Chart Panel Type
  7. Select the defined Business Object containing the underlying data
  8. Click Next, review and click Finish
  9. Confirm the Chart Type is set to Bar
  10. Confirm the Category Control Type has been added using the EmployeeID column
  11. Confirm the Value Control Type has been added using using the Sum Expression value created in step 4

Barchart

Accelerator shortcut

There is an Accelerator button named Publish to UI Layer available in the Business Logic Layer to help expedite adding Chart pages to apps. When you create a Chart type Rule, and specify the Value and Category, the Publish to UI Layer button will generate a Chart page that resides under a Reports navigation menu.