create an average line in a report

Question

Hello.
I am creating a column chart that shows me the companies created in a period of time, this part is done. But now I need to create an average line in the report that shows me the average number of companies created in a year. It is possible to do it in Appian, I am new and I do not know if it can be done.

Peter Lewis · Answer

You definitely can do this - as suggested by others, a reference line allows you to add a line and style it to the chart accordingly. The tricky part is that a reference line expects to receive a value, but it cannot automatically calculate the average. So to configure this, you will likely need to query the data, calculate the average in a local variable, and use that calculated result to display the line.