Forum Discussion
Scatter plot with 2 measures in Y Axis ( problem )
Hi guys,
I have a problem with the scatter plot, i'm doing a power curve (for wind turbines) with
X Axis: Wind speed
Y Axis: Power
Giving something like this
This is great, the problem is that i need to see (at the same time) the expected power, having something like this
X Axis: Wind speed
Y Axis 1: Power
Y Axis 2: Exp Power
The problem is that i can't put 2 Y axis in the visual. The other option that i have (and i used in other scatters) is to put in legend, but it is not possible in my system due to my database doesnt have these 3 valeus only and they are in columns (instead of rows).
Anyone knows another scatter plot visual or any help to do that?
Kind regards!
Hi dobregon
Try using a Line and Clustered Column Chart. Put the Power values in the Line area.
For the Shapes (Line Values) set the Stroke Width to 0 and turn on Show Marker, then set the marker size and color. You can Customize each series individually if you wish.
Regards
Phil
Hi dobregon
If it can help you I found a turnaround to have everything on a single view
I did it by superposing the scatter chart and the line chart visuals and disable the background. Then fix the Min and Max values for the X and Y axis, hiding the titles and the axis on one of the visuals and it does the trick !
Have fun,
Cado
10 Replies
Hi dobregon
Try using a Line and Clustered Column Chart. Put the Power values in the Line area.
For the Shapes (Line Values) set the Stroke Width to 0 and turn on Show Marker, then set the marker size and color. You can Customize each series individually if you wish.
Regards
Phil
PhilipTreacy This is very usefull, i can use it, but the problem is that i have thousand of points for me visual and the scatter plots can work with 3500 values and the line&clustered chart works with lower number of values. This produces average numbers to reduce the information
Do you know another visual / or other solution? For the moment, probably i will use itI am currently facing the exactly same issue to build power curves for wind turbines.
To have all the points displayed in the scatter chart we can check the "Don't summarize" option for wind speed and for power.
But with line and clustered column chart I don't have this option so I'm forced to have averaged or summed values ...
How can we deal with that ?
Best regards Cado
PhilipTreacy thanks for the reply, i've never used phyton visuals. i need to take a look more further in this type of visuals.
I have a simple/stupid question, the phyton visuals has the posibility to be filtered when you click on a project/device/whatever... from other visuals? like i have in other visual a map of projects in the world and if i click there i want that the phyton visuals will be filtered.
Regards!Hi dobregon
If it can help you I found a turnaround to have everything on a single view
I did it by superposing the scatter chart and the line chart visuals and disable the background. Then fix the Min and Max values for the X and Y axis, hiding the titles and the axis on one of the visuals and it does the trick !
Have fun,
Cado
I've never used Python visual yet but it's a good occasion to start 🙂
I can give you a sample data but I don't find the button to attach the file to this message and the drag & drop is not working, how do you do that ?
Regards,
Cado
