This script will add trend and average lines to any column chart (as far as I've tested)

It calculates the average for each point on the x axis and then the trend line for the chart.

Copy and paste the attached script to the widget's custom script to see!

Known issues:

• Sometimes the dashboard needs to be refreshed with F5 to display the lines
• Selecting a section of the dashboard does not mute the rest of the line, the whole line is fully visible.