Home Forums Chart Support Just the last Value from an cvs Reply To: Just the last Value from an cvs

#18620

Hi,

My file looks like this:

Date Sensor (S11) Sensor Temperature (S12) Sensor (S21) FlowMeter Total (D2) Output (A1) Output (A2) CCond Temp pH Flowmeter Retrans Prop
µS/cm °F gal % % % %
11/16/2017 00:10:00 880 69.7 8.32 0 8.8 65.8 4 12
11/16/2017 00:20:00 881 69.7 8.31 0 8.8 65.8 4 12
11/16/2017 00:30:00 882 69.6 8.32 0 8.8 65.9 4 12
11/16/2017 00:40:00 884 69.5 8.32 0 8.8 66 4 12
…..
….
11/16/2017 01:40:00 885 69.2 8.32 0 8.8 66.2 4 12

Link to a sample CSV:

I have a line chart for this which works perfect!

For some kind of Dashboard, I would need only the LAST row from this file

with all titles like “Date” “sensor (S11)” and left (Y-Axis) and only the values from the last row on the X-Axis.
Like this:

Date: 11/16/2017 00:10:00
Sensor(S11): 880
Sensor Temperature (S12): 69,9
..
and so on
..

I hope this helps