What kind of conditions are you looking for?
You should be able to build out a KPI in a calculated field to determine whether the day is a "yes" or "no".
Something like this:
IF SUM([Sales]) > 1000 THEN 'Yes' ELSE 'No' END
Thanks for the input. I'm using a "date" as a trigger point to set a "No" response for any day prior to today's date.
How about something like this?
IF [Date] < TODAY() THEN 'No' ELSE 'Yes' END
For binary calculations (yes / no , true / false) there is a better way to calculate that (less computation for Tableau);
Calc Field Name: Date Trigger
Calculation: [Date] < TODAY()
This will auto set the field to a True/False data type. True when the date is less than today, false for when the date is equal to or greater than.
Thanks, it worked like a charm! I was working at it with a machete approach and your "scalpel" fix is simple and easy.