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 ( 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.
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?
- Configure your fields using Fields List
- 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.