Forum Discussion

AdamMG's avatar
AdamMG
Helper I
2 years ago

Measures - values sorted ASC

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

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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. 

  • AdamMG's avatar
    AdamMG
    Helper I
    2 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        AdamMG
        Helper I
        2 years ago

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