Re: Compare two date fields using set analysis in table
You cannot use a set expression for row by row calculations. The set expression is executed once before the chart is built not on a row by row basis. You options are to use a replace the set with a Sum(If()) expression, or to add a derived flag fields in the load script and use the flag field in a set expression.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein