I´m trying to build a line graph (series), but I cant match the results I need.
So I have this table, generated from a form that measures water levels from different ponds at different time. (It´s an engaging community wildlife monitoring project, so anyone will be able to report at anytime on any WaterPond)
I need to build a line graph which has the water level (y) of the different ponds (series), over time (x).
I´ve tried using this data but it shows only one line (series) with all the events where waterlevel was measured, but it doesnt differentiate between WaterPonds.
I believe the way I structured the form wont allow me to do this, so I restructured the data on a new table on GSheets like this using vlookup:
One problem is solved, I have different Series for each waterpond.
The problem now is that each event carries a N/A or “0” result for the ponds that were not measured at that same time.
This means that for each date or event, I get 3 values: one correct number for the pond measured, and two zeros for those that weren´t measured
Meaning that the series drops to zero those days that the pond wasnt measured.
Im stuck here now, and Im pretty sure Im overthinking this and there´s an easy solution for this…
I hope someone has an idea that can help me unlock this thing.
Thanks for reading!