Help with graphs
Good morning all;
I have a need to use the 100% stacked horizontal line graph. It is to monitor the age of debtors (30,60,90,90+) by sales people. I want to use colours (green, yellow, orange, red) to allow a very quick first page "at a glance" comparison of the sales people. This page will sit over the line item reports.
I just can't work out how to get this to work.
Is there a definitive set of documents on how to use the graphs?
I have played with the limited examples in the user manual (and can get it to work a bit) but just don't understand it fully.
I won't worry with the SQL stuff. Suppose we had a data set (format: salesperson name, 30, 60, 90, 90+ days total debtors) that looked like this;
Barry King,32,11,13,8
Robert Brown,18,13,11,2
Tracy Chapman,6,12,2,0
..
.. there are 35 salespeople in total
..
Frank Zappa,12,5,2,12
How would I build a 100% stacked horizontal line graph that would have a salesperson per line and the totals for each salesperson shown on the line in the colour range 30=green, 60=yellow, 90=orange, 90+=red)?
I'm sure that getting it working in code will show me how to do it with the SQL.
Regards
Tony Benci
I have a need to use the 100% stacked horizontal line graph. It is to monitor the age of debtors (30,60,90,90+) by sales people. I want to use colours (green, yellow, orange, red) to allow a very quick first page "at a glance" comparison of the sales people. This page will sit over the line item reports.
I just can't work out how to get this to work.
Is there a definitive set of documents on how to use the graphs?
I have played with the limited examples in the user manual (and can get it to work a bit) but just don't understand it fully.
I won't worry with the SQL stuff. Suppose we had a data set (format: salesperson name, 30, 60, 90, 90+ days total debtors) that looked like this;
Barry King,32,11,13,8
Robert Brown,18,13,11,2
Tracy Chapman,6,12,2,0
..
.. there are 35 salespeople in total
..
Frank Zappa,12,5,2,12
How would I build a 100% stacked horizontal line graph that would have a salesperson per line and the totals for each salesperson shown on the line in the colour range 30=green, 60=yellow, 90=orange, 90+=red)?
I'm sure that getting it working in code will show me how to do it with the SQL.
Regards
Tony Benci
Comments
try making report 2pass onfirst pass gather data building strings for fixed data for use in the chart
on the second pass pass the values into the chart and make the chart visible.
Another approach is to pass data out to tchart create the metafile and display it in the report.