2 Replies Latest reply on Jul 11, 2016 6:27 AM by ammar.khwaira

    Previous records from dataset





      I have this data set in which i am :


        1) putting SP_STATUS into the filters shelf and choosing active status only.

        2) i want to show two columns:

          2.1)  count of issue   ( this one is easy as i am counting the issues for the SP 3 which is active)

          2.2) here is my problem : i want to count the issues of previous inactive SPs (using the SP_ID) , in this case i will have :

            count of issues = 2

            count prev issues = 4


      in summary:  for the current active sprint, count all issues that were in previous sprints (sprint_id is less than current active sprint).


        can this be done dynamically ? in which it keep working when adding new records to the data set (maybe some new active SPs , and deactivating the current one?)



        • 1. Re: Previous records from dataset
          Sanjay Nimbark

          Hi Ammar,


          You can do various way you can use calculation :  {Fixed [sp_status]: count (sp_id)} AND BRING TO ROW SELF AND SP_STATUS IN COLUMN SELF


          also you just use sp_staus on row self and use sp_id or issue I cant see any distinct ID but you can use any business_id on  label self to get count or distinct count


          you can share your workbook then I will guide you more .


          kind Regards,


          • 2. Re: Previous records from dataset

            Hi Sanjay


            Thanks for your reply.

            Actually my aim is to create a calculated field that can reference the current active sp_id on screen, and get anything less than this id.

            in sql something like :


            select count(issue_id)

            from  issues

            where  sp_id < &active_sp_id;


            so that each time i change the current active_sp i can get the count of anything happened before it.