Forum Discussion

PCube's avatar
PCube
New Member
4 years ago

Dynamic Average line based on the category for Scatter Chart

 

I have a requirement for Scatter Chart with Dynamic Average line for every Category.
Right now what we have is a single Average overall.
For example,
I have Country and Sales, Country has 5 values (Australia, Canada, Germany, Japan, United Kingdom) and Sales value for all of them.
So right now we can have One(1) single Average line which shows Average of Sales across all the countries, but what I want is Five(5) Average lines for all the Five(5) countries and each line will be displayed on specific Country. i.e. If Average Sales of Australia is 13000$ then it will show the Average line on Australia's data on Scatter Plot.

Have added a picture for better understanding that how the Visual should look!

1 Reply

  • Have you considered creating your own custom visual?  Or maybe look at the Box and Whiskers chart type?