I'm looking for a way to filter data on a graph to only include data that is accumulating or depleting. The simple version of this is accumulating = concentration at final timepoint > concentration at initial timepoint (or < if depleting). It however gets slightly more complicated due to the fact that the final timepoint will not always be the same - some data sets may be over the course of 12 days, some may be 14, etc. It's also common for each timepoint to really be 3 replicates, so being able to use the average of those when deciding if things are accumulating or depleting would be ideal (if not, it likely wouldn't matter much). In the included image for example, I would want to be able to filter and just show the blue line for accumulating analytes. Any help getting started would be appreciated! My goal is to have a column with an output of "accumulating" or "depleting", that way it can just be added to the data filter. Thanks in advance!
