Measures - values sorted ASC

[AdamMG]

Hi everyone.
Basically I need to create a scatter plot where I will have x and y sorted ascending and plot against each other, ... so the number are not correlated to each other anymore

My table is quite big so I think would be better to have two measures x and y?
Please help...
BTW. I am going to use DENEB and Vega-Lite to plot the scatterplot

[AdamMG]

Hi @Anonymous 
I know how to create scatterplot in vega....
I don;t know how to create the measures ... 😉

[Anonymous]

Hi @AdamMG ,

Do you mean an ordering measures of x and y?

Rank_X = RANKX(ALLSELECTED('Table'),[x],MAX('Table'[x]),ASC,Dense) 

Rank_Y = RANKX(ALLSELECTED('Table'),[y],MAX('Table'[y]),ASC,Dense) 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[AdamMG]

Hi @Anonymous 
Not really....
Please take first table and try to create second chart.

[Anonymous]

Hi @AdamMG ,

First, you'll need to create two separate measures for your x and y axes. Once you have your measures or ranked columns ready, you can use them in DENEB with a Vega-Lite specification. Here is a basic example of how you might structure your Vega-Lite JSON to plot the sorted values:

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "description": "A scatterplot showing sorted x and y values.",
  "data": {
    "name": "dataset"
  },
  "mark": "point",
  "encoding": {
    "x": {"field": "SortedX", "type": "quantitative"},
    "y": {"field": "SortedY", "type": "quantitative"}
  }
}

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.