How can i do a dot with a dynamic average of the filtered data in scatter plot

[Luiz Eduardo Zappa]

Hi,

I have a scatter plot that shows Sales vs Project Time. How can i create an dot that represent the average of Sales and average of Project Time, like the image attached. The circles are my data and the cross represents the average of each of the axes. I want this average being dynamic, when filter, recalculate the average and the dot shows the new average.

 

 

My current solution was created in excel. On the last row, I've created a line with the average of Sales, average of Project time and a column to distinguish this line from others (so I can set "shape by" this column, and distinguish the dot of average from others). But this solution isn't dynamic, if I filter anything, the value of average doesn't change, because it's a static average of all data..

How can I create this in spotfire to result in a dot that calculate dynamically the average

[Gaia Paolini]

I would like to suggest a simplealternative: to show dotted lines representing the average of x and y on the plot. See attached dxp. I have added a filter to show the lines react to it.

Gaia

[Luiz Eduardo Zappa]

Thanks Gaia. Is there a way to color areas of a graphic Like these:

[Gaia Paolini]

I cannot think of a way. It is best if you add this as a new question so somebody else can help you.

 

Gaia