In this blog, we will learn how to display the average value from a numeric column in Helical Insight.
- If we want to display the average value. Click on Travel Cost column.
- Click on more, user will get two options i.e., Quick and Advanced
- Click on “Advanced” Tab in this, you will see a function called “avg”. Double click on that function and then drag down the Travel Cost column in the selected avg function box at the bottom. click on Save button.
- Click on “Generate” report. You will see the desired output as below.
Note: These functions are specific to the database and may / may not appear based on the kind of database that you are connecting to. Please refer to below blog to add more database functions for your specific use case.