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 ...
Calculate values on rows
Summary It is possible to apply calculations and computations in the direction of the rows, that is, in the horizontal direction. To apply calculations you should select the option Calculate values on rows. Calculate data When selecting the ...
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. ...