Lines and curves: Add Average Curve that is average of all categories and is Dynamic to current Filter and Marking

Ziyang, I agree this should be easier and better supported. I have slightly modified the description to capture our discussion. Thanks for you help.

Good Morning,

I see, the subsets method won't work as it doesn't work with filtering. 

As for using the expressions, the legend is quite annoying and more importantly lacks the edibility like 'lines and curves' i.e. Different style of lines, independent thickness, labeling, and transparency etc...

Anyways, the reason I'm here is that I thought this should be a standard built-in function. This is a professional software with all the fancy curve fits already but does not have a simple and basic average curve?

Regards,

Ziyang

Ok, now I get it. It is possible to do this in Spotfire, but perhaps not a perfect solution. See the new attached file for two options to solve it. Let me know if this works for you.

Hi Niklas,

I saw the example file, what I'm asking is to have an average curve from all data lines for each X value. So for the case of this sample file, the average curve should be changing between the red and blue for every mouth. Not just a straight line.

Thanks!

Hi again Ziyang, perhaps I am still not understanding your exact need... or perhaps it is already possible? I have attached a DXP file that shows how I interpreted your question, let me know if it solves your issue?

Yes! That's it, thanks.

Ok, so for a line chart with say, Sales(Y-axis) per product category(color) over time(on X-axis), you want to add an additional line which is the average over time for all product categories together? Did I get that right?

Hi Niklas,

Thanks for replying, I was able to get an average line on the filtered data set.

What I was asking is to have the ability to draw an average curve that is based on filtered Y values for each X value.

I know Spotfire will give a single average line if no differentiation method (line by or color by) was set for a set of different Y values. I just want to have this in the 'lines and curves' so that I can add an average curve to any 'messy' graph.

i.e.: A average line that shows the trend of a set of Y value lines. Therefore aid in the understanding of the average overall trend on any graph with multiple lines.

Dear Ziyang, thanks for contributing. The default in Spotfire is that an average line created through lines and curves is dynamic with respect to filtering and data limiting. Is your proposal to be able to create a reference line that is (optionally) not based on the filtered data in the plot but rather based on the entire data set? Any example DXP or screenshot that may help us understanding the details of your needs is appreciated.