Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Does anybody have any idea?
Thanks.
Hi,
I've discovered a small flaw....
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.