Perspective XY Chart data pivot

I have a dataset,I need to show that value in an XY chart with row view. I’m attaching the images.


here I need the data in row wise as u can see its showing in column wise only.

It is not clear what you are asking.
Your table has three columns. Your chart has only two pens. Why?
Where is the data coming from?

I was trying that. as u can see the the values is being taken in column wise , but I need to get that in row wise. In vision its available under the behaviour --Extract order.



check these we have an option for that to change in vision, so I’m thinking is there any way to get that function in perspective.

That does not make sense to me because the first column is a timestamp so each of the points has to relate to the X-axis.

If you need to, you can manipulate the data in the binding by adding a script transform.

Thanks for the reply. I think you didn’t got what I asked. Let me explain.
I have a XY chart in perspective and also I put one in vision as a category chart.
so there is a database for me in which that dataset will be created, here what you are seeing is what i had created for testing.
So in perspective I’m using the same dataset which I’m using in vision. but in vision there is an option under behaviour that we extract the data by column or row. I’m asking is there anything like that in perspective.
The data is being taken as column wise, but I need it as row wise
MicrosoftTeams-image (3)
this is the vision chart like this I need the data in perspective. please shoot your doubts.


I need to plot like this rather than column wise.
I hope you are getting what I’m trying to achieve.

I assume you just have a query binding on the data property.

You need to PIVOT your data either in SQL or by a script transform.

yeah, correct. I was just asking is there any other inbuilt option in perspective to change that, because in vision we had that, we can extract order by column or row, that’s why.

One more thing is there that; if we pivot it, timestamps will become column names. And they will constantly change.

Yes, but that is exactly the format you showed in your image.

Typically in an XY chart each column represents a series, in your case the t_stamp.

There is not yet an inbuilt way to PIVOT perspective chart data. You will have to do it in either SQL or in a script transform.

Remove them in your SQL query or in the binding script transform.

I’m also quite confused as to what is supposed to happen to the timestamps ?

if you need to remove them and pivot the table, you can use this

pivoted_data = list(zip(*data))

and if you need to remove the first column (the timestamps)

pivoted_data = list(zip(*data[1:]))