Thanks Jason, this query executed.
Although it is not returning a negative result with the data you provided.
For example, the last completed week for the first habit was 4 weeks ago.
So the streak should return as -4
I also couldn't get it to work when adapting to my tables and columns, but I'm sure I'll get it eventually.
Is it difficult to return a negative result?
No comments:
Post a Comment