Calculate values on rows

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 option Calculate values on rows a form would be shown where the operation (research, divide or sum), the first column and second column of the operation.

For example, in this case a division is applied between column S and column U.



Applied the configuration, a new column would be added in the data view with the result of the operation configured.

    • 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 ...

    • 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 ...

    • Apply data formats in data view

      Summary Data formats make it possible to modify the values of data view columns and configure when the content is JSON type. To apply a format you must select the option Configure data type and column format and you could select: The column on which ...

    • Add filters and parameters in data view

      Summary Data views allow you to add fixed or dynamic filters, these are parameters. Fixed filters To add a filter you must click on the option Filter data. A form would be displayed where you should select the column on which the filter, the type of ...

    • 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 ...