multiple charts, same group 1

[jj1576]

Hi,

In the chart expert the field I have in the x axis, which is the area.areaname field in some cases has hundreds of data points. I was wondering if there is a way to chart this information using multiple graphs- it is all in the same group, so there is no way to divide it by group. Is there a way to graph say the first 10 records, then have another graph for the next 10, and so on?

 

[lbass]

If you need the areaname records in a certain order, then you should create a formula to cluster records into manageable groups by using a formula like this:

if {area.areaname}[1] in "A" to "F" then 1 else
if {area.areaname}[1] in "G" to "M" then 2 else
//etc.

Insert an inner group on this, and move the chart into the new group section.

You could alternatively create a formula like this:

whilereadingrecords;
numbervar cnt := cnt + 1;
numbervar y;
if remainder(cnt,10) = 1 then
y := y + 1;
y

Insert a group on this. The downside of this is that because it processes whilereading records, the areaname would be in original order. You could sort by the field within the formula group, but the charts would not necessarily proceed with areanames in consecutive order (from chart to chart).

-LB

 

[jj1576]

LB- That first formula worked great... much appreciated.

JJ