Hi,
I have problem loading data from resident table when I need first value for the group and there are undefined values in group. When data is sorted in UI, undefined values go to the end of list, but looks like it's not a case for load. I've tried 2 different statements:
LOAD [%Job ID],
FirstValue([Task Planner]) as [Job Task Planner]
Resident Tasks
GROUP BY [%Job ID]
ORDER BY [%Job ID] ASC,[Task Planned At] ASC;
and
LOAD [%Job ID],
FirstSortedValue([Task Planner],[Task Planned At]) as [Job Task Planner]
Resident Tasks
GROUP BY [%Job ID];
In both cases if there is row with undefined [Task Planner],[Task Planned At], I get undefined result. Even if there are rows with values in a group.