Forum Discussion
Trend Analysis - Subsequent Data Points
Hello everyone, I need to do trend analysis, such as: If the previous 7 data points are always decreasing then we flag 1 else we flag 0. I have the following code which works, but I am thinking ...
Can you try doing count distinct of Month year for the last 7 Months in one go? And if it 7 then you have all seven months data
But I am not trying to know if I have data points on those months, I am trying to understand if they are growing one after the other or not.. (at least in the 1st example).
Thus I have all those conditions with a sequence coming from the latest to the news always comparing if they are bigger than previous