I have a Slice with row condition… OR([MyDate] > “4/18/2020”, AND(ISBLANK([MyDate]), ISNOTBLANK([MyText])))
The above condition returns some rows that have a MyDate value and some that have blank MyDate.
I have a Google Doc template to produce a table using… Start: ORDERBY(SliceName[_ComputedKey], [MyDate])
In the resulting table, the proper records are returned, but not in the order I expect. I expected the records with MyDate values to be ordered by that date and all other records to be grouped together above or below. Instead, the order seems random:
If I change the ORDERBY to [MyText], it orders by that text as expected.
If I change the Slice’s row condition to just [MyDate] > “4/18/2020” (eliminating the blank date records) and use ORDERBY with [MyDate], then the report template orders the records properly by date.