Scheduled Export Dashboard - Dynamic Filters
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 hours ago
Hi all,
I'm trying to build a weekly report for Vulnerability Response, sent to the managers of the assignment groups that own Vulnerable Items (VITs).
CONTEXT
- Table analysed: Vulnerable Item (sn_vul_vulnerable_item)
- Metrics, each split by risk rating / criticality: New and Closed last week, Overdue (past remediation target date) and Open
- Each manager should only see the VITs of the assignment groups they manage
WHAT I WANT
A weekly scheduled export of Data Visualizations, embedded in the email body, sent dynamically to the managers of the assignment groups that have VITs.
THE PROBLEM
In the data source I use a Dynamic Filter (e.g. Assignment group is "Groups I manage", or a custom Dynamic Filter Option returning the user's groups) so the visualization only shows the VITs of the user's groups. However:
- The scheduled export doesn't let me choose the "Run as" user, so the Dynamic Filter is evaluated for the schedule's creator and every recipient would get the same view.
- I don't know how to dynamically populate the recipients with the managers of the relevant assignment groups, instead of adding them manually.
QUESTIONS
- Is there a supported way to evaluate the Dynamic Filter per recipient (or run the export as each recipient) in a scheduled export of Data Visualizations embedded in the email?
- How can I dynamically set the recipients of the scheduled export to the managers of the assignment groups that have VITs?
Instance release: Australia
Thanks in advance!
0 REPLIES 0