Pareto historic charts

[Everardo Hernandez]

Hi!
Have you worked with Pareto Graphs? I would like to use a Pareto chart
but accessing historic values, it seems that I only can use logical values
for input data, is it possible to use numeric values as input like a result
from a query?

Thank you.

Everardo

[tommy_scharmann]

The Pareto is really just a method of counting weighted or unweighted "factors" that all result in a single event. So, logically, logical values is the only possible input: "if this happens (1) or does not happen (0) count the occurance- the 1." So if you want to "count" historic values within certain ranges (> or <) perform a SQL query on the citadel and import the results of the query into a datatable using the execsql connection and the ODBC import/export option. Count the values within certain ranges using a combination of expressions, a moving datatable cursor, and some counters. Connect the values of the counters to the factors of the pareto. There are many ways to go about this, but this will hopefully get you started in the right direction.

Regards,
Tommy
Scharmann