I have a table of list of article that i need to track the status changes. Overtime, the online status can change and it is captured and stored in my db. I cant seem to figure out how to track the changes of it going on and off.
For example, i want to know how many times the item changes status per month or per week. I also want to calculate how many times how long the item stays on those status but most importantly when its going to 0.
2 answers
I had to edit the Window Sum calculation ( and add a wider range of dates for testing ) so amended attachment added
