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.

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

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.

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

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

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