I am creating a dependency dashboard and trying to aggregate 2 sets of data into one dashboard gadget. We have two fields "Driving Function" and "Dependent Function." The goal is to have one Gadget that can return two separate counts of two scenarios around dependencies.
Custom Fields Used:
- Driving Function
- Dependent Function
Custom Values in Rich Filter
- External Dependencies: The first smart clause is to return all external dependencies the Function has on other Functions. Naming this value "External Dependencies."
- Example: (Driving Function = "A" and Dependent Function in ("B", "C")) OR (Driving Function = "B" and Dependent Function in ("A", "C")) OR (Driving Function = "C" and Dependent Function in ("A", "B") )
- Internal Dependencies: Second is to return all the dependencies external Functions have on driving team. Naming this value "Internal Dependencies"
- Example: (Driving Function in ("B", "C") and Dependent Function = "A") OR (Driving Function in ("A", "C") and Dependent Function = "B") OR (Driving Function in ("A", "B") and Dependent Function = "C")
Data Example:
- Functions:
- Function A
- Function B
- Function C
- Data Feeding Dashboard:
- Driving Function A | Dependent Function B
- Driving Function A | Dependent Function C
- Driving Function B | Dependent Function A
- Dashboard Controller Filter
- Function A: ("Driving Function = A" or "Dependent Function = A")
- Function B: ("Driving Function = B" or "Dependent Function = B")
- Function C: ("Driving Function = C" or "Dependent Function = C")
Expected Dashboard Results:
- Dashboard Controller Filter:
- Function A: ("Driving Function = A" or "Dependent Function = A") Selected*
- Gadget with Custom Values on Smart Filter:
- External Dependencies: Count 2
- Driving Function A | Dependent Function B
- Driving Function A | Dependent Function C
- Internal Dependencies: Count 1
- Driving Function B | Dependent Function A
Actual Dashboard Results:
- Dashboard Controller Filter:
- Function A: ("Driving Function = A" or "Dependent Function = A") Selected*
- Gadget with Custom Values on Smart Filter:
- External Dependencies: Count 3
- Driving Function A | Dependent Function B
- Driving Function A | Dependent Function C
- Driving Function B | Dependent Function A (Should Not Be Counted)
- Internal Dependencies: Count 1
- Driving Function B | Dependent Function A
The External Dependency results are merging all the conditions into one result instead of honoring the dashboard filter. Any help would would be greatly appreciated. Thanks in advance.
