Group and calculate data on columns

Group and calculate data on columns

Summary

Data views allow groupings and links on columns.


Group data

To group data you must select the option Group by columns

You should select and add the columns on which the group would apply. Initial values would be grouped together.



Once the columns by which to group have been defined, the option of calculations would be enabled.


You may select the operation (count, add or average), the column on which the operation would be applied and the name or item to be taken.



Once the settings have been made, you could view and edit them.




In the revision step, the outcome of the group and clustered links.




    • Related Articles

    • What is a data view

      Summary The platform does not require an off-line ETL process to extract data from the origins, but associated with the view, find a set of rules that the data engine interprets for check the source on demand or periodically, extract the data updated ...

    • Select data and headers

      Summary Data views allow you to select the data and define the headers or titles that would be available in APIs methods. It is possible to make selections from the entire table, columns, column intersections and rows. In addition, it is possible to ...

    • Add aliases in data view columns

      Summary APIs method templates allow you to obtain the values of the data view columns by position or alias name. Here we explain how to configure the aliases of the data view columns. Add alias To add aliases to the data view columns you must select ...

    • Data sources from URLs

      Summary The URL connector allows you to collect data from HTTP(s) and FTP protocols. To collect data from a file hosted in a URL, you must go to Data sources > From URLs Configuration Enter a URL with a clear link from where you want to collect. ...

    • Data sources from REST/json web services

      Summary The REST/JSON web services connector offers all the capabilities needed to connect to such sources. This option allows you to collect data from REST/JSON web services or configure writing actions, and then create data views and exhibit them ...