Thanks! This has helped a bunch! However, I'm now getting an error that it has the '>' operator received different types in the where command. Through some testing, I have found out that the comparison of "Consumption > last2days*1.2" is the one causing issues, in particular "last2days*1.2". I am able to run the code if I change it to "Consumption > last2days", however the final result that appears is that Consumption is lesser than last2days. This is the SS of the results that showed up when I added your modifications with "Consumption > last2days" instead. Edit: I just digested and understood what the code does, so that 1 result was actually supposed to appear. Is there any way to create a chart that will plot those situations that only have days where the consumption is higher than the previous 2 days?
... View more
