I'm trying to create a dynamic average line in a bar chart on Sisense (orange line).My sample data looks like the below. Is there a way for Sisense to calculate the average of all teams by default (i.e. $305K) and then display the orange line on the bar chart? In addition, if the user only filters to 2 teams e.g. Boston Red Sox and New York Yankees, the average would be changed to $135K and the line would automatically changed to $135K?Attached is my sample data and chart in excel

Thanks for your reply! It's in the right direction but the formula you shown isn't correct. I followed the documentation to create the correct formula and it worked now.

How to create an average line in a bar chart? | Help and How-To

MoreDiscussions

How to create an average line in a bar chart? | Help and How-To | Sisense Community