1 Reply Latest reply: Jul 5, 2016 2:36 PM by Rakesh Boorgu RSS

    Select if Max() of Related Data is Positive

      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?