HOW to define a avg line in a bar chart

Question

Hello Knowage community,

Am currently building an analysis dashboard in which am using line and bar charts, am wondering if it's possible to add an average line on the bar chart like the picture below, if so how to implement it.

Thanks ;)

Comments

Hi marwen,

try to follow these steps:

---

Hello Marco,

thanks for your quick reply, i already tried this step, but the second series has diffrent values from the first one, and that gave wrong average, any other ideas !

thanks

---

Hi,

maybe you can add a column by using a calculated field that computes the average, and then use that column as the second serie.