7 Replies Latest reply: Jul 25, 2013 2:37 PM by Shannon Lepore RSS

    Expression syntax question



      I’m struggling with setting up an expression to be used in a chart. 


      My dimension is Job_Group

      My expression is sum(Duration_In_Minutes)


      What I’m trying to achieve is that the expression display data only for the most recent Effective_Date (max Effective_Date?).  The chart also needs to be set up so that it doesn’t restrict data based on any other filtering done within the rest of the document.


      Any guidance would be greatly appreciated.