Historical data for motor speed

I have a trend where I am displaying the speed of a motor. This motor runs at a fixed speed (occasionally the operators will adjust the set point, but this is a maybe-once-a-day type occurrence). The motor starts and stops as necessary according to process conditions irrelevant to the questions at hand.

Here we can see a trend of the motor speed (green/blue), as well as the motor running feedback from the drive (orange). I have configured the motor speed trend pen with “step after” interpolation. I would expect the motor speed trend to essentially mimic the motor running signal with only a very slight trapezoidal shape at the start and the end for the ramp up/down time (a few seconds). However, it doesn’t do this:

Instead the trend line appears to ramp up/down over the entire length of the motor run time, which in most cases is several hours.

When I change the motor speed pen to be a scatter plot, we can see that there appear to actually be data points at these locations:

…which (a) should not be the case because the motor is not ramping up over the course of two hours, it’s running at a fixed speed, and (b) the historical data setup should not be storing data that way.
Screen Shot 2022-06-20 at 11.41.41 am
Out of curiosity, I set up a display with a table, and bound the table data to a tag history query for that motor. What I’m seeing is that as the motor ramps up to speed, data points are stored several times per second, at increments of less than 0.01Hz, while the history configuration suggests that it should not log a value until the difference is 1.0Hz.

Following that, I just have page after page of the exact same speed logged, again, several times per second, despite the fact that it should not be logged while at the same speed for at least an hour, according to the tag history settings. Given that the minimum time between samples is 1s, I can’t see how it could ever be sampling multiple times on the same second in any case.

What’s going on here?

In case it’s important, here’s the tag binding configuration for that table

Incorrect. What you’re seeing is the result of interpolation. Use the AsStored query mode instead in your Table binding and you should see your raw data. Unfortunately you can’t display raw data in the Power Chart yet so you’re kinda stuck with what you’ve got for now. I created a post and feature request a few months ago relating to a significant number of poor useability issues ([FEATURE] Increase usability of the Perspective Power Chart component)

1 Like

Riiiiight, yes, when I change that binding to as stored I get only three results: 0, 6.5, and 0 again. That makes sense.

I figured that interpolation would just be determining how to draw lines between the points that DO exist, which should result in this working correctly, as opposed to how to draw the line between points after interpolation has been applied. I’ll check out your feature request and add a my vote to the tally.

1 Like

PS. the best we have at the moment to show useful charts is to decrease the max time between samples. I set this to 5mins for my trended tags which guarantees points every 5mins. It increases your data usage and also the niceties of having a succinct dataset goes away, but at least your trends display ok.

1 Like

Yeah I had that idea and I’m tossing up whether or not I should present it to the client as an interim solution. I’d rather not if I can avoid it, but if needs must…