I've done some googling but haven't found anything about this. I have an area chart with two series (not stacked). Is there a way to keep the series with the smaller average values in front of the one with the larger average values, so that the user can hover over the smaller series and get it's tooltip? Which series is smaller or larger will change based on user selection.
Thanks,
Brian
Message was edited by: Brian Adams
Hi Brian,
I have a solution that can implement this feature. But using avg. as the comparison will not always result in shorter series being shown properly.
Considering your data is like this.
Create 2 calculated fields that look like this.
Create your chart like this using dual axis and you can always see your lower values in the front.
Hope this helps.
