7 Replies Latest reply: Dec 8, 2017 8:23 AM by Janani Reddy RSS

    Expression to loop through a set of records for a dimension

    Janani Reddy

      Hello,

      I need help in writing an expression to get a sum for each department and every application number in the department

      Currently using a bar chart to plot this data and dimension used is department

       

      Can we write a measure to loop through every application number for  a department and do the sum only if atleast one row has the application status approved and end stage as end

       

      Can this be done using set analysis??

      A screenshot of the data is pasted below. This is how the data will be for one iteration(1 department >> 1 application no>> all the stages it has passed)

       

      Untitled.png