Performing calculation on stored data

[Everardo Hernandez]

Hi all, maybe a Lookout developer more experienced than me can help me
with this one.
I am storing information in a Citadel database regarding production
levels and timing, I would like to perform some statistical calculations
such as Average, Std deviation, etc. I am trying to figure out how to pass
the information from the database to the Calculation Objects, I read in the
documentation that are 35 samples available as a data member in some
objects, but I wonder if there is a way to perform the calculations in a
larger number of data. Any idea?
Thank you in advance.

Everardo

[Preston Todd Johnson]

Good Morning Everardo,

Citadel has built in statistical functions. These are easily experimented
with using MS Query to access Citadel from MS Excel. You might also refer
to the reference manual or online help regarding the ODBC compatibility of
Citadel. With these tools, you can use the SQL object within Lookout to
make queries on Citadel and invoke the built in statistical functions.

Good Luck

Todd Johnson


"Everardo Hernandez" wrote in message
news:38b5c068@newsgroups.ni.com...
> Hi all, maybe a Lookout developer more experienced than me can help me
> with this one.
> I am storing information in a Citadel database regarding production
> levels and timing, I would like to perform some statistical calculations
> su
ch as Average, Std deviation, etc. I am trying to figure out how to pass
> the information from the database to the Calculation Objects, I read in
the
> documentation that are 35 samples available as a data member in some
> objects, but I wonder if there is a way to perform the calculations in a
> larger number of data. Any idea?
> Thank you in advance.
>
> Everardo
>
>

[John Dunlop]

Hi,

We have done a lot of work with analysis of large amounts of data using the
SQLExec object. Its a great way of getting at the data. Just be aware that
MSQuery adds in a lot of extra text into the SQL string that you dont need
in Lookout.

Bye,
John