Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Sort the date colum alfabetically instead of by expression
The following happens when I sort alphabetically: