From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

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
(925 Views)

The test database

0 Kudos
Message 2 of 3
(904 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
(828 Views)