The YESTERDAY relative filter is out of the box - so you have no option to change how that behaves.
You'll have to create your own custom formula field that returns a date on the object and then use that within the filter of the report.
Create formula field that returns a date (ex. Business Days - Yesterday)
Can utilize WEEKDAY() which returns 2 for Monday ...
The not-sent reason can only be found in the NotSent Tracking Extract and the NotSentEvent SOAP API object.
For the first, you'll need to create a Not Sent data extension to accept the import. Then you can configure a Tracking Extract in Automation Studio with these steps.
Extract (check the Not Sent Box)
Transfer (from Safehouse)
Transfer Unzip (to ...
At this point, you would want to reach out to Support. There could be a lot of different issues that could be causing this.
As a best practice, please ensure that the Salesforce System User is assigned the System Administrator profile.
You will also want to ensure that the Marketing Cloud API User is integrated, as well as your own Marketing Cloud user. ...
There is no way, out of the box, to change this.
Your idea can be a workaround.
Hide "Report" tab on user's profiles
Create your own custom "Web" tab
Use the URL you see when clicking on "All Reports" - it'll be something like: https://domain.lightning.force.com/lightning/o/Report/home?queryScope=everything
Give user's access ...
You can do the following if you're able to group your rows (maybe by owner, for reporting on sales moving leads to a certain status).
Create a number row-level formula that denotes whether your criteria (where) is met. If it is met, give it a 1 (for counting).
Create a Summary Formula column ...
Out of the box, no. When creating a lookup field, you get a dropdown of all objects you can select and the roles you've defined for your Account/Opportunity teams is not available for selection.
The reason for this is that SalesTeamRole is not an object itself. It's a standard picklist that is used on the junction objects between Account/Opportunity and User
Your issue is you are doing an INNER JOIN, which requires the record to exist in BOTH tables (DEs) in order to be returned. The OPs code is basically saying return all records that match on both tables but are empty on the second one. Since it cannot exist but also not exist, it returns 0.
As you are looking for records that are both in and NOT in the _Click ...
Welcome to SFSE!
Please review _Click Data View documentation, where it is shown that the SubscriberID field is not nullable, thus you cannot have WHERE clause with cl.SubscriberID is null and INNER JOIN at the same time, which makes you have 0 records in the result.
You should either adjust conditions in the WHERE clause or select another type of JOIN, ...