Following are the mathematical functions that can be applied to the column: Group by Sum Distinct Count Max/Min Avg Users can observe that by default, categorical variables take ‘Group by’ function and Numerical variables take ‘Sum’ function. These default applied functions can be seen and changed in the Meta data file which is present in
In this article we will learn about how to perform mathematical functions in Adhoc. Here, we will perform mathematical functions and analyze cost of travel by an employee using travel data. Drag the columns “Employee Name” and “Cost”. On generating report, at the bottom, which may contain details of multiple travel by a single employee.
We will use Travel data for creating Top 5 average costs of travel & Bottom 5 average costs of travel. The steps for the same are as follows: Drag ‘Employee name’ & ‘Travel cost’ column Apply ‘Group by’ function on Employee Name and ‘Average’ function on Travel cost. Then generate the report. Arrange the