O'Reilly logo

Pentaho Analytics for MongoDB Cookbook by Harris Ward, Joel Latino

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Grouping data in reports

In this recipe, we will take you through the steps required to display raw data into groups. This can be useful if we want to create group sum functions. In this recipe, we will order the data into groups of counties and cities. This will then allow us to add sums for each city or country group.

Getting ready

To get ready for this recipe, you will have to make sure your MongoDB instance is running.

How to do it…

We are going to use a PDI transformation to populate the report from a previous recipe. This transformation will give us a list of orders by country, city, and product line:

  1. In Report Designer, navigate to File | New.
  2. Click on the Data tab in the top-right corner of Report Designer.
  3. Right-click on the Data item in the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required