Scheduled Export Dashboard - Dynamic Filters

tmamouros
Tera Contributor


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:

  1. 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.
  2. I don't know how to dynamically populate the recipients with the managers of the relevant assignment groups, instead of adding them manually.

 

QUESTIONS

  1. 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?
  2. 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