Forum Discussion
Scatter plot with 2 measures in Y Axis ( problem )
- 5 years ago
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
- 5 years ago
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
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
- dobregon5 years agoImpactful Individual
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 it- Cado_one5 years agoResolver III
I 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
- dobregon5 years agoImpactful Individual
Cado_one it seems that we are doing the same visuals (exactly wind turbine power curves :D)
The scatter plot is the good one to create the visual becasue it has a limit of 3500 points (the line chart doesnt have that number of points)
So, if you are goind to do Power VS wind, you need to use the scatter plot
The scatter plot has an option to show yo differnet points depending of the legend, so if you want to compare and you are able to use it is the best way
Related to the line clustered chart, i have used 3 measures (power, powerexpetect and wind speed) all of them with average agregation becasue the visual as it can't take all the points it needs to aggregate the information. The problem in that type of vissual is the precission, becasue scatter plot has more precision (due to number of points) than this chart.
On the other hand you can use phyton visuals that it can give to you everhing