Filter based on future value

Question & Answer
1

I have a column flag that flags 0 and 1 for certain other columns based on dates. Currently it is flagging 0 only, but will also flag 1 in future. The requirement is : the analysis should filter to flag 0 until the column flag starts flagging 1, which will not happen until couple of months in future, as the column starts flagging 1, the analysis should not filter for 0 , and should start filtering only for 1.
Is this possible ?

2

Create a calculated column as such: {Flag} = maxOver({Flag},[], PRE_AGG) and filter where this calculated column equals 1. Depending on how your data is set up you may need to change PRE_AGG to PRE_FILTER

1 Like
3

Thanks John for your resolution.
this was helpful