Jump to content

Plotting both gragh in one screen (Scatter plot and line Chart of their average)


HYEONGJU AHN

Recommended Posts

I can think of two ways as of now -

  1. Create a Spotfire Visualization Mod for same and use it. This is bit time consuming, difficult approach for first time development; but ​will be very smooth in future usage.
  2. Use Python ​chart libraries to bring end results in Spotfire. It is easy to implement, support little old versions as well, but comes with a few limitations like you cannot Mark data here. An example of the implementation is demonstrated here -https://youtu.be/MPKpIG2h6JU
Link to comment
Share on other sites

I could think of a simple way, but not perfect as I could not find a way to plot a line and a scatter plot together, but only two columns in a scatterplot, connected by lines (with marker size minimized).

The Y columns of your scatter plot would be like:

[Y], Avg([Y]) over (LastPeriods(10,[X]))

where 10 is configurable if you use a document property to hold its value.

I tried it on the Iris dataset and plotting Sepal_Width (rowid is a calculated column I created from rowid()).

The blue like is the raw [Y] and the green line is the [Y] averaged over the previous 10 values of [X]

image.thumb.png.2c186b4a7c0341a8c38554e889d4f61c.png

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...