Jump to content
We've recently updated our Privacy Statement, available here. ×

Line Graph Smoothing


Nick Napier

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...