With WebDataRocks you can organize your data in various ways. This article explains how to define which data is shown on the grid. Each field can be selected to rows, columns, values or report filters.

To start fields configuration you will need Fields List ( menu_fields button in Toolbar). It looks the following way:

Pay attention to the section All Fields on the left. It contains all fields from your data source. Drag these fields to the boxes on the right, such as Rows or Values.

Use Add calculated value button to compose new values based on your data source. If you want to change aggregation for some field in Values box, press sigma icon next to its name.

After configuring fields the way you want, just press APPLY to see the changes on the grid.

How to show certain fields when loading data into WebDataRocks?

  1. Configure your fields using Fields List
  2. Save your current configuration and apply it when setting new report (for more details see Saving and opening reports)

Want to check how fields configuration is defined in the report? Find slice section in our online demo.