Multiple charts, from multiple tables on one layout?

[Scott Pon]

Is it possible to show multiple charts from multiple tables on one layout?

 

I have one chart showing Open Orders, X-Axis is Days Open, Y Axis is # of orders

 

Then I have a chart that shows # orders opened vs # orders Closed, X-axis is year/month, Y axis is # of orders.

 

They are both coming from the same database, but the source data is created differently.

 

but the main question is the first one: Is it possible to show multiple charts from multiple tables on one layout?

We might want to put on the same screen Employee performance, and People trained, or specific service performance.  

 

I hope that makes sense.

 

Thanks in advance.

[David Jondreau]

Sure. Gather your data into variables using scripts and base the charts on the variables.

[Scott Pon]

Sure. Gather your data into variables using scripts and base the charts on the variables.

 

I understand what you are saying, but I'm not sure how to accomplish this.

I set up a variable for my X-Axis Labels, and a variable for my Y-Axis values.  I loop through my records and create a comma delimited string for each.

Then in Chart setup, I set the X-Axis labels to the variable and the Y-Axis values to the variable.  

but the Chart did not come out correctly.

 

Let me know what I'm supposed to do, or please provide me a link so I can go read up on this technique.

 

Thanks.

[David Jondreau]

1) Your data should be return delimited, not comma delimited.

2) The chart settings should be "Use data from: Current Record (delimited data)".

[Scott Pon]

Ok I got it.

 

I used Variables (Set Variable) but it did not work.  So I created fields (define fields) and used a global (text) field.  then i set the chart to " Current Record (delimited data)". as you had specified.  And now it works.

 

Thanks for your help