mardi 16 décembre 2014

Creating a dashboard based on yes answers to audit questions



I dont know if this is possible as I am relitivly new to sharepoint.


I have a list that contains a unique row for each application we have in production.


I am trying to create a dashboard showing percent of application that are meeting General Control rules.


Currently I have 2 controls I would like to track.


The first is based on 2 fields field 1 is date application was "Deployed to Production" if that equals the date in the field "Integrity Checker Run" that row is a positive, if not it is a negitive. The percent should be percent of total application that are positive.


The second is easier I think as the filed is a list filed with 2 values yes/No, percent should be number of total applications that have a yes.


I do believe we are using Sharepoint 2010 This Dashboard would need to update as the columns are updated either adding a new row or adding a yes to the column.








0 commentaires:

Enregistrer un commentaire