Hi All,
I am currently working with two joined datasets. Each dataset has a date for each row that gets added. I have outer joined those datasets and am now trying to make sure that the number of date entries are the same in each data set.
I can visually tell that they are the same but I am trying to write a beast mode to confirm via a true/false output.
Because one of the datasets takes a bit longer to trickle all of the information in, I need to make sure the number of rows are the same from the same day of the prior week. (i.e. does September 7th match with September 7th)
Here is the beast mode I have so far.
Any suggestions on how to correct this syntax?