8 Replies Latest reply: Apr 14, 2017 9:10 AM by omar bensalem RSS

    Bargraph: Shows all data 100%

    Supriya R

      Hi,

       

      i have bar Graph, where i Need to put graph for Q1 and Q2,

      where Q1 has many options, but i need to show count for only 'Agree' and 'Strongly Agree'.

      where Q2 has many options, but i need to show count for only 'Agree' and 'Strongly Agree'.


      If i put graph it shows all 100%, Please find attached qvf file.

       

      Dimension 1:

      if(match(question_id,'Q1','Q2'),if(question_id='Q1','GOOD IMPRESSION',if(question_id='Q2','SUCCESSFUL IN EDUCATING')))

      Diemnsion 2:

      if(match(answer_text,'Strongly Agree','Agree'),answer_text)

       

      Expression:

      count({$<answer_text={'Agree','Strongly Agree'}>}distinct lender_offer_id)/count(distinct lender_offer_id)

       

       

      Please help me on this

        • Re: Bargraph: Shows all data 100%
          Daniel Ansell

          Hi

           

          Is this what you are wanting?

           

          All i done was change expression to:

          count( lender_offer_id)

           

          However maybe you wanted  count(DISTINCT lender_offer_id)

          Bargraph.PNG

          • Re: Bargraph: Shows all data 100%
            omar bensalem

            Try to add Total in your expression and then format it as %:

            count({$<answer_text={'Agree','Strongly Agree'}>}distinct lender_offer_id)/count(distinct TOTAL lender_offer_id)

             

            Capture.PNG

             

            ps : you do not need this part {$<answer_text={'Agree','Strongly Agree'}>} since you're already aggregating your expression by this 2 values (Agree and strongly agree); these are you're dimension already.

             

            So, count(distinct lender_offer_id)/count(distinct TOTAL lender_offer_id) will have the same effect