How to Bind Sepasoft MES Analysis Dataset to Perspective Timeseries Chart?

[Daniel_Calderon]

Jonathan. You are correct, I typed the wrong class name on my post, and I have edited it to fix that.

Your method works perfectly. Thanks for that.

value.getValueAt(r, col).getTime()

I also discovered that I can use this other function to just reformat as a string that perspective happily interprets as date:

system.date.format(value.getValueAt(r, col), "yyyy-MM-dd HH:mm:ss")

Finally, for what it's worth, I was struggling with timeseries chart bars widths, until I found another post here with a nice explanation of how using XY chart provides much better flexibility to create bar charts.

Stacked Bar Chart in Perspective - Detailed Steps

Few months ago I needed to create a stacked bar chart and ran into issues (Perspective 8.0.14 Time Series Bar Chart width - #3 by arun1). There are few posts here but they don’t give a full picture. Here are the steps that I took to create one: First it is worthwhile to note that we need to use the XY chart and not the TimeSeries chart because the width of the bar chart is calculated automatically based on the amount of data in the x-axis so if you have sparse data in a wide time range then th…

So thanks a lot, I will mark this as solved. (Still sort of hoping Sepasoft team provides a more straightforward way to connect datasets with perspective charts.