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

[Daniel_Calderon]

Hi All,

I am using Perspective MES Analysis selector to pull some data from OEE Downtime. I am connecting this data to an MES Analysis Table, and I am getting the results I want with an hourly timestamp.

Now I would like to use this data in a perspective Timeseries bar chart. Since the type of data that the mes analysis selector returns is “mes dataset”, I am binding it to my chart series.data prop and doing a script transform to reshape the dataset to a list of objects I can plot in bars. This is working and I am able to create this new list.

The problem I am having is the time key. The timestamp that comes in the mes dataset is a java.util.date (Edit: I had java.util.time before) type which I have not been able to properly cast into a time format that the perspective prop can interpret and properly render the timeseries bars.

So I would like to know whether I am following the correct approach to connect MES results to Perspective charts, or there is a better/easier way to do it. If this is the only way, any help with the time key would be welcome.

Thanks All.

[jespinmartin1]

Does java.util.time class even exists? I think you mean java.util.Date

In that case, cast it to Unix Time with .getTime() method

[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.