Group data

How to group your data

Events in a data table can easily be grouped to facilitate analysis. The result of grouping is a data table presenting all the different row value combinations of the grouped fields. Grouping is also required in order to subsequently apply aggregation operations to the data.

Server and client grouping periods

In Devo, groupings use two different time periods to group the data. After grouping the data, you will see two different tabs in the applied search operations bar, each one indicating one of the grouping period types:

• Server grouping period - The first tab is the grouping period requested to the server. When you select a large period for your grouping, the server is requested to download a smaller interval, and is then recalculated to show the period you chose. 

• Client grouping period - The second tab is the grouping period used by your browser and is the actual period you indicated in the grouping. Modifying this period does not request data to the server again, but only recalculates the groups locally. 

For example, if you group data by three hours, Devo automatically sets the server grouping period to 30 minutes. Then, data is recalculated and grouped every three hours, which is the period you indicated in the query window.

Open

To edit the period of a grouping, you can either click the pencil icon in the second tab of the grouping or click the gear icon of the toolbar and select Operations → Change client period.

Open

Related article:

• Build a query using LINQ