Dynamic AI Support Forum

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

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