I have a dashboard tab with various reports built on the same Scoped App table, each referring to a specific field that tracks an associate taking some action on a record. The intent is that when a single associate is selected in an Interactive Filter, each report would be updated to show how many records that particular associate has associated with each step of the record's lifecycle:
I put a Reference Interactive Filter on the page that filters associates from our sys_user table assigned to the teams handling these records. Further in the Interactive Filter definition, I have tried Interactive Filter References for combinations of the various fields (all on the same table) to drive counts for each status value (accepted, escalated, etc.). It works well when I have one value defined for the Interactive Filter Reference (meaning when I define the reference to the "Accepted By" field, the Accepted Today values are accurate. The Escalated Today values are correct when I define the reference to the "Escalated By" field. However, none of the other report counts are accurate). As soon as I add two or more Reference fields to the Interactive Filter, none of the reports show accurate data (unless the "All" value is selected in the filter; then all data is accurate. It only becomes inaccurate when I choose an individual associate).
Is there a problem with defining more than one Reference field? If so, is there a workaround or any suggestions to accomplish this result? I haven't seen anything in Docs or other posts limiting the number of Reference fields to the SAME table.
