Steve Fernandez Posted February 12, 2020 Share Posted February 12, 2020 Took me a while to understand what the complaint was with my chart. Turns out the Horizontal Line function from Lines & Curves is drawing it's line based on the average of all resultant values of Y. This is inaccurate. It should be, or we should have the option to select, the average based on all the values. Aside from submitting to Ideas, is there any workaround (currently on 7.11 LTS) to get a line that represents the avg of all values Things like a calculated column won't work for a % calculation that has to span the entire data set of the time period and filter options. I tried Curve from Data Table and a Custom cruve, but that didn't work either. Seems like others would have wrestled with this same "feature" of Spotfire. Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted February 25, 2020 Share Posted February 25, 2020 You can use combination chart with expression like Avg([sales]) over(All([Axis.X])) as [AvgY] and plotting AvgY as Line from Series Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now