How can i show historical data in columns by months

[NebRu]

Hi all,

I'm using DIAdem for historical data trending.I'm selecting some period of time (for example 03.04.2007-03.21.2012) and I want to show the data in columns (like bars) which are representing the average value of each month of the selected period.How can you help me to implement this.

Regards,

Ruben Arshakyan

[JL@NI]

Hello Ruben,

Try to implement a new channel to calculate the arithmetic mean of the data over each of those date ranges. Once you have a new channel of averages over that range, create a report that has a 2-D Bar Chart for that channel.

Regards,

Jeff L.

[NebRu]

Hello Jeff,

How to create for example 5 arithmetic mean data in one 2-D Bar Chart. To implement statistics.

Regards,

Ruben Arshakyan

[Brad_Turpin]

Hi Ruben,

How is your data stored?  Could you send over some example files, either post them to this forum thread or email them to me (brad.turpin@ni.com)?

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[NebRu]

Hi Brad,

The data is stored by Shared Variable Engine. As we set some deadband values for logging, the logging intervals may not be the same. 
I attached the example file (it's a TDM file).

Regards,

Ruben Arshakyan

[Brad_Turpin]

Hi Ruben,

If you're saving the states of shared variables, does that mean that you're using LabVIEW-DSC and saving to a Citadel (LabVIEW_DSC) data base in addition to the TDM file?  If so, DIAdem can interface to the Citadel data base and use its time resampling functionality during the data import process to accomplish what you want.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[NebRu]

Hi Brad,

Yes I using Labview-DSC and saving to a Citadel data base.But I can't represent this data in bars,like statistics of month.

I want represent our data like this.Like average of month.

Regards,

Ruben Arshakyan

[NebRu]

Hi Brad,

Yes I using Labview-DSC and saving to a Citadel data base.But I can't represent this data in bars,like statistics of month.

I want represent our data like this.Like average of months.

Regards,

Ruben Arshakyan

[Brad_Turpin]

Hi Ruben,

That looks like a DIAdem graph, so I'm guessing your trouble is not configuring the graph display (bars) but rather loading the data averaged by month or averaging by month after loading all the data.  The tricky thing about averaging by month is that monthly bins contain a different number of seconds from month to month.    I hadn't thought of that when I asked if you were using Citadel to load data into DIAdem-- the custom binning you can do when loading from Citadel is based on windows with a constant number of seconds each.  Please post the TDX file that goes with the TDM file you zipped and posted, and I will be able to look at your data and send you back a VBScript that bins the data by month and calculates the monthly average.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[NebRu]

Hi Brad,

Please find attached file. I have many data, and I would like to present the form of bar. Is there any way to creat VBScrip universal?     
I am looking forward to your answer.

Thank you in advance.

Regards,

Ruben Arshakyan