Periodic Data Analysis using a set of values

[sudhin_sudh]

Hi Everyone.....

       I require to create a data analysis graph,which represents the set of datas in a week or a day in graphical view.

       I have a excel sheet which automatically updates the resultant value whether OK or NOK in its 8th column as attached in screenshot.Now i would like to create a GRAPH (any graph ,user friendly) which shows,how many number of OK/NOK result has been occured in a year,month, week or in a day.Depends upon the sorting value the customer.If they require for a particular month or a year or a particular day. 

       First column in excel shows the date and time and I have to sort according to that.

Hoping for a positive response

Sudhin_sudh

[Nghtcrwlr]

Open the excel file --> extract Colum H and search for OK or NOK. create array for OK with corresponding date and the same for NOK. Wire it to a graph.

You can also use Excel Get Data.vi,if you have the Report Generation Toolkit.

[sudhin_sudh]

Thank you so much for ur reply....

         But what about the sorting of FROM date & TO date and the Graph should be in between the these two dates (FROM &TO).

Hoping for your positive replies

Sudhin sudh

[Nghtcrwlr]

Use the Sort 1D array function from the Array pallette.

[sudhin_sudh]

Thank you for ur reply...

But the excel sheet is continously updated and i have to make a data analyis based on a week or a day. I am confused in how to make front panel UI which will be easier for the customer to analyse the data.

       Is there any way of clean and easy UI which will help in data analysis factor.In this data analysis i would like to make sorting based on for a week or day (or both).

       For Eg:- If i provide input FROM to TO date and press enter.I should get a graph which shows me the OK/NOK status.

[Nghtcrwlr]

Can you post the code you did so far, so that i can have a look?

[sudhin_sudh]

HI Everyone...

     This is the coding that i have done for getting the time and value graph.

But here the graph is not comming accuratly to the cordinate point. The X and Y plot graph are coming accuratly but the Cordinate points of them are not accurate.

[GerdW · Accepted solution]

Hi sudhin,

when you want to analyze the timestamp strings in your array you should combine date and time and use the correct format string:

[sudhin_sudh]

thank you for your reply..

        Now how can i add next days date in the next row of 1st column continously.I have to create a database for all the days. Now how can i add dates row by row automatically in the 1st column 

[GerdW]

Hi sudhin,

so you ask how to build arrays?

If you do so I recommend to take the FREE online resources to learn LabVIEW…

(Or play with array functions to learn how they work!)