Hello! I have a field in a straight table that includes dates, but for some entries there is no data and the message shown is 'No information'. I would like to sort the data showing dates from oldest to newest and the entries with 'No information' to be at the bottom. How can I do this? I have tried Chart Properties->Sort->Sort by expression-> =max(Date)
This sorts the dates in the desired rder, but the entries with 'No information' appear first. How can I send them to the bottom?
