I am trying to do simple calculations like showing the % of relationships that meet specified criteria by CSM and display it in GS Home as a KPI widget. I’ve been able to aggregate the # of relationships that meet the criteria and # of total relationships, but when creating a formula field in the report builder everything is calculated on a line by line basis. In Data Designer I was able to recreate the same thing and get the total aggregated % but when placed in GS Home it does not filter by the current user (in our case this is the Relationship CSM).
Has anyone figured out how to show CSM roll up KPIs in Gainsight Home?