Ivan Berry

Is there anyway to turn on lane labels and the background grid when building a display as part of a spy.Assets class?

I have been able to achieve this previously with the workbooks class by pulling in the worksheet via spy.workbooks.search and modifying the sqTrendStore, but that is an extra step that I would like to avoid if possible.

Yes there are upstream calcs, including max, but they are all working.

Thanks Patrick, I'll sign up for an office hour. 

I just tried that, no luck. Thanks.

OK new problem, any ideas on how to overcome this same error for this type of seeq formula:

$s.aggregate(totalized('hr'),months(), durationKey()).setUnits('BTU/month')

I've tried round and resample. 

Thankyou John! That round(12) did work, 🎵 I'm on the road again 🎵

This is quite crafty. Have there been any changes to the best way to do this? Not that there is anything wrong with it, just checking.

I wouldn't have figured this out if I was on a desert island with only a locally installed seeq instance, very lucky for the seeq forums 😄

Hi,

I'm having a bit of trouble pushing a description for metrics, it doesn't seem to take effect:

                       {
                            'Type': 'Metric',
                            'Name': row["Name"],
                            'Measured Item': {'ID': row["ID"]},
                            'Statistic': None,
                            "Description": row["Description"], 
                            'Thresholds': {
                                'Lo':  row["Low Limit"],
                                'Hi': row["High Limit"]
                            }
                       }

Is there some special structure to use to specify the description?

Regards,

Ivan

Thanks Teddy, great suggestions!

Thanks Teddy.

As a follow up question, are there any potential ways to make the prediction tool fit faster? 

One idea I had is to resample the target variable to 10mins data as we are not that interested in high frequency predictions, wondering if I also need to bother resampling all the input predictor variables, or does the regressionModelOLS function automatically do that?

$target.resample(10mins).regressionModelOLS($condition.toGroup(capsule("2022-01-01T14:32:00.000Z", "2022-06-01T20:32:00.000Z"), CapsuleBoundary.Intersect), false, $a,$a^2,$a^3,$b,$b^2,$b^3,$c,$c^2,$c^3,$d,$d^2,$d^3,$a*$b,$a*$c,$a*$d,$b*$c,$b*$d,$c*$d).predict($a,$a^2,$a^3,$b,$b^2,$b^3,$c,$c^2,$c^3,$d,$d^2,$d^3,$a*$b,$a*$c,$a*$d,$b*$c,$b*$d,$c*$d)

I am currently testing the idea to run a prediction for a large number of signals, generated from an Asset Tree.

Are there any performance traps to be careful of? Are there any events that can cause the prediction model to be refit (other than updating the training window or inputs)?

This is the function we are looking at using.

$target.regressionModelOLS($training,
        false,
        $signal)
    .predict($signal)

These signals will be used to generate treemaps, organizer topics and potentially Odata endpoints.

Dropping  `Permission Inheritance Disabled` worked.

Thanks Mark!

Thanks Mark. I'm in seeq datalab.

Quote

`spy.__version__`
'56.1.7.184.7'

Our seeq server is 

Quote

R56.1.7-v202209191154

I am running into an issue when we push a signal to a workbook that exists in a folder.

One of the signals has security applied, that doesn't necessarily match the parent permissions of the folder and workbook.

The error we get on spy.push is:

Quote

Failed to write item in batch request: The property 'Permission Inheritance Disabled' is malformed or its value 'true' is invalid. May not modify the property directly: Permission Inheritance Disabled.

I tried both enabling and disabling permission inheritance for the workbook we are pushing to, that didn't resolve the error, is there any other permission inheritance to consider?

This is what I am currently doing to get the enumeration value from an enum type return:

I need to add signals together that have missing values, if some values are missing in one of the signals, the rest should sum together, and the missing signal is zero.

This link below was a helpful discussion, essentially I would like to do the same thing, but with a sum, instead of a max.

Thanks for any pointers.

thanks ?

Is it possible to create an inverse or NOT capsule?

For example, I have capsules that mark equipment failures, I would like a capsule that is the inverse of failure, not failed. The reason I would like to do this is so I can aggregate run hours between failures. 

Thanks for any pointers!

Regards,

Ivan