Plott data from a function

[gorros]

I use some global variables for summing up parameters, and I would need to use these data in a graph. Is it possible, and if so, how do I do?

 

[synapsevampire]

Why would you need a sum of a parameter, do you mean the sum of a field?

You can use formulas as data for a graph, so if you've created some values in variables, you can then reference them in a formula for use by the graph.

Obviously you've posted nothing technical about your environment nor requirements so it's hard to know.

-k

 

[gorros]

I have tried that, but the formulas don't show up in the list of available parameters.
I am searching a table, that is linked to two other tables. Lets call them A B and C. A islinked to B with "pid", and C to C with "dept".
For each "pid", there are a number of records in B linked to this "pid". I need to sum up the number of distinct values ("code") from B (there could be multiple records with one "pid" that have the same "code" value. And tere is an undetermined number of possible values of "code". These individual sums (for each "pid") should be added to the corresponding "code" sums for all records in A with pid "pid" that belong to a "dept". Then I should plot number of "code" (for all code values) for each dept.
Not sure this make it very clear, but hope it help me get an answer

 

[synapsevampire]

Please post your formula, stating it doesn't show up won't help us understand why.

-k

 

[gorros]

it's more like I use global variables, and "post" them using a function.

But I don't know how to single out distinct records (that will count only one occurance of one code value for a single pid). Or can I somehow do a something like a "SELECT DISTINCT" inside Crystal, or just for a specific field?

I'm new to Crystal, and feel a little out on deep water