Hi All ,
i am able to get data in px -timeseries graph from Timeseries DB if we have only two axis(that is x and y ) but now i want to get data in predix multi timeseries graph graph then how can i do because now i am getting signals from predix machine, we have signals for every axis ( like RPM , Massflow, T_CP, Stress_CPt, T_surface, Stress_Lim) for HP and IP Rotor.
In our time series we have ingested data based on signal uri like /tag/SANDA_HPT_ROTOR.AMAY26DT951_XV02 this will give value of x and RPM value other signal will give x and Massflow and so on .
But here we are getting different X (Time ) value for different signal but for our multi time series graph we want all signal values on the same time that means x value should be same for all signal like below . {"x":1157360400000,"RPM":302.2635,"Massflow":12.10283,"T_CP":20,"Stress_CPt":-6.011713,"T_surface":43.49023,"Stress_Lim":123.314}. here x is the time .
Can any one please suggest me how can i do this .
Answer by Tom Turner · Jul 16, 2018 at 11:04 PM
You'll want to query on an Interval and then average across multiple datapoints in the interval.
Say Pressure is collected every second. Temperature every 10 seconds.
If you do a query for an interval of 10 seconds and average within the 10 seconds, the datapoints will be aligned across the 2 Tags.
Something like that, you'll have to play with the queries. Use the predix-tool-kit to try out various options. https://predix-toolkit.run.aws-usw02-pr.ice.predix.io/#!/tsQuery