Version: V 7.2.x

Modules: Lifecycle

Product Area: Dashboards - Dynamic (Applied to "AFX - ROI Metrics" Global Dashboard)

Time to apply: ~40 minutes

Summary

RSA IGL Recipes - The 12 Dashboards of Christmas - Summary , 2020 - Part 12 of 12

This ROI dashboard is created to help show the ROI from your RSA IGL deployment, in both hours and $ (or whatever currency you want to use).

This dashboard can be used be admin teams to show the value they are providing back to the business, due to the AFX module. 

The goal of this dashboard is to help you understanding some initial ROI saving by using RSA IGL, in both hours and $

Example Image (Click to enlarge)

Key Notes

• This chart/report/dashboard is supplied "as is" - any modification of this item is done at your own risk. 
• If you have issues applying this chart/report/dashboard, please comment below for help, DO NOT contact the RSA Support team.
• If you would like more assistance with this chart/report/dashboard or for help in creating other chart/report/dashboards, then RSA Professional Services (RSA PS) is available to help.
  • Please contact your RSA Account Manager or local RSA Sales Rep or reply below for further assistance.
• Do not forget to set "User Constraints" on your dashboards - otherwise everyone will be able to see them.

Dashboard Prerequisites

For this dashboard to work, there are 2 key values you need to establish first.

1. The "average" time (in hours) that a normal request would take, that's now being processed by AFX.
   • For example, you could assume that the average time per request is around 15 minutes to complete manually end to end. 
   • So each time AFX process any request, on average, this would save around 0.25 hours of effort.
   • NOTE: the value needs to relative to "hours" (so 15min = 0.25 hours or 10min = 0.16 hours
2. The "average" cost (in whatever currency you choose) that a normal request would take, that's now being processed b AFX. 
   • For example, you could assume that the average cost per request is around $5. This could be established by looking at the cost/hour you pay someone who is completing these kinds of manual processes.
     • So if that rate is $20/hour and they complete 4 requests per hours, then you can assume its around $5 per request in cost (on average) 
   • NOTE: The value can be in any currency you wish, it just needs to be an average value overall. .

Once you have established these 2 key values, you need to add them into the UI, so they can be called by the dashboard. 

Steps:

• Log in as an Admin user
• Go to "Admin/System"
• Under the "Settings" tab, Press the "Edit" button at the top
  
• Scroll to the bottom of the page, where there is a section called "custom"
• Add the following row and press the "save" button
  • Left Box = dashboard_afx_cost
  • Right Box = Your value from above (eg. 8, if you decided each AFX request was about $8 saving per item on average)
• Add the following row and press the "save" button
  • Left Box = dashboard_afx_time
  • Right Box = Your value from above (eg. .25, if you decided each AFX request was about 15min time per item on average)
    
• The end result should be as follows:

The parameter values must be EXACTLY the same as above, which is case sensitive, as this used in the SQL

DO NOT include any currency symbols in your "value", this should only be a "number"

Remember the "dashboard_afx_time" value is "per hour"

Details

The dashboard, contains the following charts and reports, all of which need to be created first, before you can implement this dashboard. Please see these documents for more info on how to create the required dashboard objects first:

1. RSA IGL Recipes: AFX Telemetry - Fulfillment Trending 
2. RSA IGL Recipes: Telemetry Chart - ROI AFX Hours 
3. https://community.rsa.com/docs/DOC-115402 

Dashboard Implementation

You MUST follow standard change request process and apply this solution in your lower environments first, before moving this to Production.

1. Create each of the reports/charts as listed above in the "details" section
2. Make sure you have complete the pre-requisiits as shown above to have the 2 values stored correctly.
3. Once all these charts/reports have been created successfully

4. Go to Admin / Dashboards

5. Under "Welcome Dashboards" click the "+ Create Dashboard" button
   
    

6. Under the "Dashboard Overview" tab

   Dashboard Name: ROI - AFX

   Enabled: True/Checked

   Display Sequence: 20 (you can update this value in future, to move where this dashboard is shown)

   Layout: Proportional Layout,  select the option with 3 results, as shown below. 
   Note: you can modify this as per your needs, if you want to show more/less charts overall. 
   

7. Under "Dashboard Components" Tab

8. Click "Add Component" button

9. Add each of the charts/reports, listed above, you must do this step for each chart/report.

   
    

10. Under the "User Constraints" tab set the correct level of access for who should see this dashboard. 
    Note: For this dashboard, you might need need to set any constraints, as only specific people can see review-results. If you did want to add something, then you might want to set this to just AveksaAdmin and users with Aveksa System Admin access.

    
    
    This is the "Advanced" SQL that can be used, if you want to copy and paste the below

    /*AveksaAdmin, System Administrators*/
    users."User Id"='AveksaAdmin'
    or users.id has approles (('Aveksa EDC','System Administrator'))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

     

11. Click "OK"

12. The new dashboard should now be shown and display data dynamically for each review result