Extracting SQL Data For Chart Usage

Discussion created by laguna92651 on Mar 13, 2018
Latest reply on Mar 14, 2018 by laguna92651

I'm charting using SQL, I have a SQL expression for the x axis and one for the y axis, they work fine. I've used the FETCH FIRST on the two axis to get the first 5 values in the series, what I need to do is to sort the y axis by value, so I can get the top 5 values, how would I sync the x axis with the y axis so the correct x label lines up with the y value?


If I bring back the x and y values in a single SQL statement, and sort the pair in the SQL statement, how do I extract the y value and x value separately from the SQL expression for use in the chart axis?