Nick Napier Posted January 16, 2019 Share Posted January 16, 2019 In short, please "smooth" the line in the attached .dxp file. For more details... I have a line chart in Spotfire. On the x-axis is date and the y-axis is an amount. Specifically, the y-axis is the weighted average of a minimum amount for each date on x-axis for each CAT_1 for each CAT_2. The y-axis expression is WeightedAverage( [Weighting Factor] , Min([NUMERIC_1]) over (Intersect([CAT_1],[CAT_2],[DATE_1]))) as [Weighted Average of Minimum] The line is very jumpy so I'd like to smooth it. I thought of using the moving average expression, perhaps using a 7-day moving average. However, I'm not sure how to nest my WeightedAverage function (shown above) in the MovingAverage function because that's also a compound function. Any ideas on how to smooth my line chart Link to comment Share on other sites More sharing options...
Michael Daiy Posted January 16, 2019 Share Posted January 16, 2019 https://community.spotfire.com/questions/how-improve-calculation-max-value-... I had a similar goal when I asked this question. Although it may not seem like the same issue at first look, the answer is the same. Check out this thread for a good solution. I was able to successfully smooth my curve using the advice in the comments. 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