Creating a Dashboard line chart component

In this recipe, we are going to add a line chart component to a dashboard. Charts play an important role in dashboard design. There are all sorts of chart components available in the CDE Dashboard editor, but we are only going to cover the line chart component. You will notice that many of the charts out here have the same options (not all options, but some).

Getting ready

To get ready for this recipe, you first need to start the MongoDB server with the same database as that of the last chapter. You will also need to start the Pentaho BA Server using the server control scripts. Once it is started, you should be able to log in to the BI Server.

How to do it…

Proceed with the following steps:

  1. In the PUC, go to File | New | CDE Dashboard.
  2. Save your dashboard at Public | Pentaho MongoDB Cookbook | Dashboards, with the name Line Chart Component.
  3. Click on Settings on the CDE Main Menu.
  4. Click on the Layout tab.
  5. Then click on the Add Row button.
  6. Select Row.
  7. Set the Name property to ROW1.
  8. Set the Height property to 300.
  9. Click on the Data Sources tab.
  10. Expand the Kettle Queries data source category.
  11. Click on the Kettle Over kettleTransFromFile data source.
  12. Set the Name property to QUERY1.
  13. Click on the Browse button of the Kettle Transformation File property.
  14. Navigate to Public | Pentaho MongoDB Cookbook | Transformations.
  15. Select Chapter7-getorders-summary.ktr.
  16. Click on OK.
  17. Set the Kettle Step name property to OUT, like this:
    How to do it…
  18. Click on the Component tab.
  19. Expand the Charts category.
  20. Add CCC Line Chart.
  21. Set the Name property to LINE1.
  22. Then set the Title property to Orders Summary.
  23. Next, set the Datasource property to QUERY1.
  24. Finally, set the HTML Object property to ROW1. The following screenshot should appear:
    How to do it…
  25. Click on Save. We can now preview our dashboard as follows:
    How to do it…
  26. Click on the Opened menu on the Pentaho User Console and select Browse Files.
  27. Navigate to Public | Pentaho MongoDB Cookbook | Dashboards.
  28. Select the Line Chart Component dashboard file.
  29. Click on Opened on the left-hand side menu.
    How to do it…

How it works…

In this recipe, we created a simple but functional dashboard. After creating an empty dashboard, we created a data source based on a Pentaho transformation. We finally added a line chart component to the dashboard, hooked it up with the QUERY1 data source, and placed it on a layout row called ROW1.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset