In this article we will learn about different column level operations on selected columns in Adhoc. On clicking drop down arrow on right side present in any selected column, we can see many functions which are :
- Use as Filter
- Use as Co-Ordinate
- Aggregate Functions (Sum, distinct, count, Min, Max, Average)
- Group By
- More Function ( Mainly use for applying advanced function)
Clicking on Use as filter will use this selected column as Filter.
Clicking on Hidden will render this column data invisible in the report.
We have many functions like Sum, Distinct, Count, Max, Min and Average. Except Distinct, these functions will only work on numeric data.
Group By allows to do a grouping. For example if we want to see total travel cost by employees, we will have to do a Group By on the name of employees, and sum on the cost of travel.
More functions allows to have advanced data type specific operations.
For more info, contact us at firstname.lastname@example.org