Good day Community,
I find myself with a business requirement where I need to set the adhoc view filter based on a condition.
This report is setup with a report event to send out an email to recipient list, so I cannot filter it manually before running the report.
The adhoc view is set to filter data with effective = day - 1. this works the majority of the time however on a Monday it needs to be day - 2, because of Sunday not having data and Saterday's data only coming through on the Monday.
If I could use something similar to Assure's @if_else function with @day_of_week and @now functions within the filter's between fields, I could accomplish this.
But I don't think that is possible. See attachments for more info.
How would I accomplish this in Perceive?
Attached files
PerceiveAdhocViewFilter.png
SimularToAssure_val_if_else.png