Profound Logic Forums

I have a chart that I want to display the last x number of records for a customer. I just need to sort by date but I need to in descending order not ascending order. Due to the large number of records for each customer I am only doing x number of records so my chart does not become unreadable. Is there a way to sort in descending order? I have a logical file that sorts in descending order but the chart just sorts it back to ascending order.

I was able to figure it out I just used standard SQL logic and added DESC to the field order by.

Interesting challenge! Have you tried specifying the descending sort within the chart's configuration itself? Sometimes the chart engine overrides the logical file's order. Also, consider if your data source is inherently sorting ascending. If all fails, perhaps pre-sorting the data with a CTE or subquery before feeding it to the chart, for better Drift Boss like control.