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


      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)