oracle11g - Oracle SQL Developer plot scatter graph

Question

I'm attempting to use the report function within Oracle SQL Developer to plot a scatter graph of my data. The scatter graph should be fairly simple: one field on the X-axis again the second on the Y-axis. This is the query I'm using to pull the required data and group it together:

SELECT
    customer_x_coord,
    customer_y_coord
FROM
    customers
GROUP BY
    customer_x_coord,
    customer_y_coord

The data type of both fields is 'NUMBER'.

I'm using this as the SQL for the report and changed the style to chart and the chart type to scatter. But then I can't get the data map correctly. I'm presented with mapping options: 'Group' 'Series' and 'Value'. How do I use these options to create a graph that plots customer_x_coord on the X-Axis against customer_y_coord on the Y-Axis?

question from:https://stackoverflow.com/questions/65876708/oracle-sql-developer-plot-scatter-graph

Answer 1

As SQL Developer said, you need to have 3 values returned by your query. If there's none, make it! For example:

select 
  'My graph' as series,         --> this
  customer_x_coord as group,
  customer_y_coord as value
from customers
group by customer_x_coord,
         customer_y_coord

series value won't change (its is a constant) but it doesn't matter; now you have 3 columns, so use them to plot the graph.