So i have 2 columns (they sum measures count distinct of user ids. over time)
ie. col 1 col 2
Jan 85 100
Feb 60 75
Mar 78 125
is there a way to compare these two columns and create a 3rd column of the unique ids that fit both criteria.
ideally. the ids of col2 February that were in col 1 January, and col2 March that were in col 1 Feb. etc.
doesn’t necessarily need to be a table calc. if there is a way in sql that would also work.