I have the following problem: I want to schedule a Look on daily basis. It should be a visualisation (single value) which is based on a Yes/No variable per day, where the YES/NO variable is dependent on a measure. This measure is shown as a comparison value. Example of the data:
Date | Completion Rate | Is there an issue? 05-01-2017 | 100%| NO 04-01-2017 | 70% | YES 03-01-2017 | 50% | YES 02-01-2017 | 90% | NO 01-01-2017 | 80% | NO
Example of the viz:
NO 90% completion rate
What I want to do:
I want to send out this Look (the single value) ONLY when Is there an issue? is equal to YES. When this is not the case, I don’t want anything to be sent out.
What I tried:
I tried only displaying the first row of the data (hiding all others) and then the viz only changes when a new day with YES is entered (hide “No’s” from viz is enabled). However, the data/results do change every day (even though the viz does not change on a daily basis), and hence, it will send out a new e-mail everyday, even though Is there an issue? for the latest day is NO.
Does anyone have an idea how to solve this problem? If I need to provide more information, please let me know.