tdms filter by time

[ChandranKajang]

Dear friends,

I've been trying to do this for a while and gave up. I am looking for help here.

I have 6 parameters of RH and temperature logged in a tdms file with absolute time base, at interval of 1 second. I created one file for each day. This works fine.

At the end of the month, I need to create a report with hourly minimum, maximum and average values. 

The problem I am facing is, how can I filter the tdms file based on time (hourly). I don't know what function will do this. I need to filter out the hourly data and calculate hourly min, max and mean.

Looking for some advice on this.

TQ [Chandran]

[deppSu]

Hi Candran,

If I understand correctly, the amount of data you log in an hour should be same. Then you can map the "hourly" filter condition to the amount of data. You can set proper "offset" and "count" for "TDMS Read", read data out and calculate hourly min, max and mean value.

[ChandranKajang]

Hi,

TQ for the reply but I can't use the amount of data for the filtering. In my data, sometimes there won't be any data, eg when the power failed or something. During this period, no dat awill be collected. I need to have some intelligence in the filtering (check the real absolute time). Any suggestion?

[deppSu]

Well, if that is the case. I'm afraid I can't think out any solution for your existing TDMS files to be filtered by hour.

I think next time when you log using TDMS, you can record the time information into the TDMS file as well, for example, you can set a timer and logging to a different channel at the interval of an hour; Or you can also record a channel at hour interval with the data of the amount of raw data logged in this hour.