5 Replies Latest reply: Dec 15, 2017 6:21 AM by Sunny Talwar RSS

    Previous selection data in KPI

    Neha Pathak

      I have one Date filter and  KPI showing total count of EMPLID (employee id)  for both current and previous selection data

      when no filter is selected In the Current expression data as of maximum date is coming  and in Previous expression '0' should come

       

      but when I remove the filter in the Previous Expression data  for all the dates is coming 

       

      Eg-

         

      when no selection of filters
      Previous count of employee idCurrent count of employee id
      0500 (data of recent/max month ie month4)
      When I select value of month within the filter ie month2
      Previous count of employee idCurrent count of employee id
      1500(data of all the months)700

         

      MonthCount(EMPLID)
      month1200
      month2700
      month3100
      month4(latest)500

       

      I want instead of 1500, 500 should come