LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

chart with hours and parts produced

Solved!
Go to solution

Good Morning,
I'm new to LabView and I needed your help.
I am trying to build a program to find out how many parts a specific machine has produced.
Every time the machine produces a part, the date and time is registered in the SQLITE database.

Using SQLite Library Dr James Powell
- Put it in the database. - it's  OK (the date and time are separated and saved as STRING
- Get the info of the  database - it's OK,. however with a problem:
- the hour (hh: mm: ss) comes in 1D String array
- the number of pieces (comulative) is in 1D inter array

And now I wanted to make a graph that would give me the number of (comulative) pieces produced by the machine and the time.

The problem that I can't make the graph "connected to terminals off different types - cluster of 2 elements and the sink is a 1D array of cluster of 2 elements)
Can someone help me make this chart hours / pieces produced
Thank you.

Download All
0 Kudos
Message 1 of 3
(927 Views)

The test database

0 Kudos
Message 2 of 3
(906 Views)
Solution
Accepted by topic author MDominguez

ok - I've already managed to solve it.
I recorded the hours on Julian Day in the SQLITE database and the graph is easily executed without conversions (number of pieces produced per hour).

0 Kudos
Message 3 of 3
(830 Views)