Each row represents an account.
Each account's contract starts on a variable date. The contract starts on the "2015 Contract Start Date" and ends on the "2015 Contract End Date". Those dates are different for each account.
I want to evaluate each account's performance (based on the sum of "Allergy Tests") during their own distinct contract year (ie between the "2015 Contract Start Date" and "2015 Contract End Date")
I tried this:
IF [Month End Date]>=[2015 Contract Start Date] AND
[Month End Date]<= [2015 Contract End Date] THEN
It didnt work due to come aggregate and non-aggregate dimensions. Any Ideas? .twbx attached.
Instead of this:
SUM( IF [Month End Date]>=[2015 Contract Start Date] AND
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...