line chart top 5 sort order

[koolskins]

I'm running CR10 on an Informix database and have a line chart showing the total count of purchase orders that were CLOSED and the total count of purchase orders COMPLETED over the last 5 weeks. I have a TopN = 5 and ORDER on the date set to EVERY WEEK but the order is not consistantly going from the oldest date to the newest. It keeps showing up like 5/15, 5/8, 5/22, 5/29,6/12. Anyone know why the chart order would do this?

rw

 

[lbass]

Are the dates currently displaying in order of the highest to lowest counts? Are the dates in the right order if you remove the topN?

-LB

 

[koolskins]

The topN is printing in sum order based on whichever of the sums is picked, i.e., sum of CLOSED or sum of COMPLETE. I put a formlue in to group all dates prior to 5/18/2005 into that date and ran the chart for ALL instead of TOPN and it still mixed up the order of the dates.

rw

 

[lbass]

My point was that I think topN will reorder the groups by the topN amounts. Using "All" doesn't eliminate the topN--it just sorts all groups by the topN amounts. If you remove the topN altogether (delete the summary to sort by), then if the dates are out of order, it is probably because of your datatype. Are you using a string for a date? If so, you should convert it to a date datatype so that sort will be correct or else use the following format "yyyy-MM-dd" for the string.

-LB

 

[koolskins]

Okay, you answered my question. I didn't realize that the topN would sort primarily over the numeric value verses the reports primary order by which is based on the date. I've rewritten the report to group by a formula where I have all records older than 35 days old put under one date that is the 36th day's date (from currentdate) and then all records > than (currentdate-35) put under their own date. This will give me my 5 week cycle and replaces the need for topN. Thanks for the response.

rw