I'm trying to create a line chart that will show the first value for each date.
My data has several lines of data for each date ([Date of Visit]), i want to create a Line chart that just selects the very first entry ([Time called]) for that date.
On each of the lines of data is also a field 'Location', when I now filter by 'Location' it shows up as no data (because obviously we've created a table that just compiles the first data point in the 'Called for' field).
I think I need a different method of pulling this together.
if you want to know the first call schedule (called for) you use: FirstSortedValue ([Called For], ID, 1) if you want to know the time of the last call (return) you use FirstSortedValue (Returned, -ID, 1)
