I have three categories: [Project], [SalesOrder], and [Issue].
Each [Project] has multiple [SalesOrder]s, and each [SalesOrder] has many [Issue]s.
Each [SalesOrder] has a [DaysRemaining] field, to track whether it's still active.
I need to get a Scatter Chart to display (so using its dimension field) only [Issues] that are part of an active [Project]. An active [Project] is defined as a [Project] associated with at least one [SalesOrder] that has positive [DaysRemaining].
Anyone have any ideas?