4 Replies Latest reply: May 18, 2018 1:51 PM by Jahanzeb Hashmi RSS

    Set analysis with identifier 1-full selection

    Steven Cheah

      Hi

      Based on my sample data below, I wish to calculate the 'IF' policies for each agent.

      AgentPolicy NoStatus
      A1IF
      A2IF
      A3LA
      B4LA
      B5IF
      C6MA
      C7LA

       

      The expected result is:

      AgentNo. of IF policies
      A2
      B1
      C0

       

      Used this expression: count({1<Status={'IF'}>} distinct([Policy No]))

      which gives me expected result but when I apply filter for Agent B only, the charts still shows the full result for agent A,B,C.


      How can do I both:

      1. Calculate all IF policies disregarding the 'Status' filter (e.g. LA/MA) and count of IF policy remain as expected result and not '0';and

      2. List is shortlisted based on the agent selected in 'Agent' filter?


      Thank you in advance. Kind regards.