How to Visualize the overall average of a column value without Grouping

Published:

In some cases, you may want to compare the value of a column with the overall average of the column without grouping based on the x value of the chart. This can be achieved through the expressions.

Steps to Compare Column Value with Overall Average

Create an expression for the overall average of the column.

Expression Format:
```
TOTAL(AVG(columnname))
```
Configure the Chart widget with the newly created average expression and change one of the chart types to a line.

Go to the properties tab, under the basic setting. You can see the Chart Type and Axis option

Click the change button to open the chart type and axis settings dialog

Chart type allows you to switch the widget view from current chart type to another convertible chart type. change the Average_Rank column to line type
Now, chart renders as follows.