Can you share a screenshot of the calculation editor with the error?
Tableau Zen Master and Forums Ambassador
Follow @helpmedatablick for your @Tableau tip of the day
What's the intent? If the subscriber is an Admin, then you can email a Hotmail address or any internal address, but if you're not, then you are only allowed to email internally?
If so, it should be something like:
IF [subscriber_license] = 'Administrator' THEN 'yourname@hotmail\.de|' + [default_allowed_recipient_addresses]
( I'm assuming that [default_allowed_recipient_addresses] is using something like '.*@yourdomain\.com' )
The pipe character ("|") functions as an OR operator in regex. So by saying "yourname@hotmail\.de|.*@yourdomain\.com", you're saying "the recipient addresses must all match either "email@example.com" OR end with "@yourdomain.com".
well at the end what I try is to send a standard pdf report to different users who do not have a Tableau License. They could be within our company or outside the company.
With Administrator I think I got it I simply have fogotten my Role is Server Administrator and not Administrator. Nevertheless it is not really clear to me how I know can you VizAlerts with the reports I already have created.
I hav the the VizAlerts trigger in my schedule and I have uploaded the VizAlertsConfig to my Server. But I really don´t know how to combine the excel file with the sheet I have
Now that I look at the viz, I think the subscriber_license field isn't really very helpful, because it doesn't tell you when the user is an Administrator. So that example calculation I provided is not correct.
To work around this, your calc should probably hard-code the names of the administrators, or a project that only they can post in. Also, make sure you fix the ELSE statement on line 3 of your calc--it should be ELSEIF.
IF [workbook_repository_url] + '/' + [view_name] = 'VizAlerts_RecipientTests/ToCC' THEN '.*'
ELSEIF [subscriber_sysname] = 'jbruckmann' THEN 'mcoles@yahoo\.com|' + [default_allowed_recipient_addresses]
ELSEIF REPLACE([subscriber_email], '.', '\.') // Period must be escaped in regex