Column chart behaving differently

Technical support

Moderators: Bob Cergol, Data Access, Cintac

Column chart behaving differently

Postby JeffKimmel » Fri Jan 11, 2013 4:20 pm

All,

I have a basic column chart attached where I'm showing totals. When I order by date, I get the columns sorted from highest to lowest. When I order by equipment, the other grouper, it stops doing that. Is there a way I can get the report to order from high to low. Also, when I try to show the top n the report doesn't work.

Thanks,

Jeff
Attachments
ByEqp.png
ByEqp.png (12.96 KiB) Viewed 23144 times
ByDate.png
ByDate.png (17.32 KiB) Viewed 23144 times
JeffKimmel
 
Posts: 22
Joined: Tue Sep 18, 2012 6:12 pm

Re: Column chart behaving differently

Postby Carsten Sørensen » Mon Jan 14, 2013 12:18 pm

Hi Jeff,

I think your idea of using a TOP n report to sort the columns is the right approach. However the TOP n report must be build on Equipment as a group and IdleHours as the total that is being sorted. Try not having more than those 2 elements on the report.

Best regards,
Carsten
User avatar
Carsten Sørensen
Certified Dynamic AI Professional
 
Posts: 304
Joined: Thu Aug 16, 2007 1:25 pm
Location: Copenhagen


Return to Technical Support

cron