You could create a calculated field based on Referral Urgency and have it give you the goal
IF [Referral Urgency] = 'Nursing Priority 1 - Within 4 Hours' THEN .9
ELSEIF [Referral Urgency] = 'Nursing Priority 2 - Within 48 Hours' THEN .85
ELSEIF [Referral Urgency] = 'Nursing Priority 3 - Within 7 Days' THEN .75
ELSEIF [Referral Urgency] = 'Therapy Priority 2 - Within 2 Weeks' THEN .75
ELSEIF [Referral Urgency] = 'Therapy Priority 3 - Within 4 Weeks' THEN .5
Then compare the two fields:
IF [Within Target Flag] >= [Goals] THEN TRUE
Thanks Joseph, but I am having trouble with the calculated field becoming a dimension and while I convert it to measure it does not give me the right answer. Can you add your solution to the attached file I sent in my previous message please.
Here you go! I made up the goals, but you should be able to edit those values as you please to get your desired results.
Ref Priority 210917.twbx 228.5 KB
Thanks Joseph, that surely helped me a lot. much appreciated.
No problem! If that solved your issue, please take a minute and mark my comment as the correct solution so others who find this will know what to do.