Custom column feature allows user to create a separate derived column which could be required for creating adhoc reports. This is useful when the data is required in different format as that of present in the database. Some use cases of Custom column are mentioned below:
- We have ‘time of call’ in the database. Let us say, we want to know for a particular time range, how many calls were received. Then a custom column can be used. In the custom column, we could write formulae to derive the time from time-stamp, then group it and count it.
- In a sales data, if a cost of item column is present. We could create a custom average column which would show the average cost of the item.
Following are the steps to create a custom column:
Step 1: Double click on the custom column button as shown in the snapshot above
Step 2: A window will appear in which user can give a name to the column and write the SQL query to get intended output
Step 3: Click on save and then ‘Generate report’
For More Info, Contact us at firstname.lastname@example.org