I think at the heart of my question is how can I let the user set the size of the "lag"? E.g. If user-A has consecutive day scores from 1st April of 5,4,6,4,5, then the viewer interested in her if he sets the start date to 2nd April and the end date to 3rd April (or 5th April). He is not interested in her if he sets the…
But if I add such a function to the dataflow, then would it not be a fixed value? We'd like the viewer of the card to choose the range of dates within which to compare. Is it possible to use the valuesin a quick filter set by the viewer within a calculated field and then use that in a filter?
Here is a screenshot of the current graph. The viewers would like to see *only* users with a score that's higher or lower on 17th April than it was on the 3rd April (where those dates are chosen by the viewer). At the moment, there are many users who have unchanged scores and they are not the main area of interest. Thanks.