Forum Discussion

Ailteir's avatar
Ailteir
Helper I
7 years ago

Forms Pro Survey reporting

  Using the data structure and resultant pivottable image above I am trying to produce a multiple card visuals that shows the number of projects where a filtered question was answered "no"...
Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Ailteir 

 

Can you provide the data sample you base your pivot on?

Best Regards,
Mariusz

Please feel free to connect with me.
Mariusz Repczynski

 

Ailteir's avatar
Ailteir
Helper I
7 years ago

Can do but not quite sure how I do it through the forum?

  • Ailteir's avatar
    Ailteir
    Helper I
    7 years ago

    All data is fictitious;
    Team Member,Project,Question,Answer,AnswerValue
    Elizabeth Barnes,Project01,Question01,Yes,1
    Elizabeth Barnes,Project01,Question02,No,0
    Elizabeth Barnes,Project01,Question03,Yes,1
    Elizabeth Barnes,Project01,Question04,Yes,1
    Elizabeth Barnes,Project01,Question05,No,0
    Elizabeth Barnes,Project01,Question06,Yes,1
    Elizabeth Barnes,Project01,Question07,Yes,1
    Elizabeth Barnes,Project01,Question08,No,0
    Elizabeth Barnes,Project01,Question09,Yes,1
    Elizabeth Barnes,Project01,Question10,No,0
    Elizabeth Barnes,Project02,Question01,No,0
    Elizabeth Barnes,Project02,Question02,Yes,1
    Elizabeth Barnes,Project02,Question03,No,0
    Elizabeth Barnes,Project02,Question04,No,0
    Elizabeth Barnes,Project02,Question05,Yes,1
    Elizabeth Barnes,Project02,Question06,No,0
    Elizabeth Barnes,Project02,Question07,No,0
    Elizabeth Barnes,Project02,Question08,Yes,1
    Elizabeth Barnes,Project02,Question09,No,0
    Elizabeth Barnes,Project02,Question10,No,0
    Elizabeth Barnes,Project03,Question01,Yes,1
    Elizabeth Barnes,Project03,Question02,No,0
    Elizabeth Barnes,Project03,Question03,Yes,1
    Elizabeth Barnes,Project03,Question04,No,0
    Elizabeth Barnes,Project03,Question05,Yes,1
    Elizabeth Barnes,Project03,Question06,Yes,1
    Elizabeth Barnes,Project03,Question07,Yes,1
    Elizabeth Barnes,Project03,Question08,Yes,1
    Elizabeth Barnes,Project03,Question09,No,0
    Elizabeth Barnes,Project03,Question10,Yes,1
    Elizabeth Barnes,Project04,Question01,No,0
    Elizabeth Barnes,Project04,Question02,No,0
    Elizabeth Barnes,Project04,Question03,No,0
    Elizabeth Barnes,Project04,Question04,Yes,1
    Elizabeth Barnes,Project04,Question05,No,0
    Elizabeth Barnes,Project04,Question06,No,0
    Elizabeth Barnes,Project04,Question07,No,0
    Elizabeth Barnes,Project04,Question08,No,0
    Elizabeth Barnes,Project04,Question09,No,0
    Elizabeth Barnes,Project04,Question10,No,0
    Elizabeth Barnes,Project05,Question01,No,0
    Elizabeth Barnes,Project05,Question02,Yes,1
    Elizabeth Barnes,Project05,Question03,Yes,1
    Elizabeth Barnes,Project05,Question04,Yes,1
    Elizabeth Barnes,Project05,Question05,No,0
    Elizabeth Barnes,Project05,Question06,Yes,1
    Elizabeth Barnes,Project05,Question07,No,0
    Elizabeth Barnes,Project05,Question08,Yes,1
    Elizabeth Barnes,Project05,Question09,No,0
    Elizabeth Barnes,Project05,Question10,No,0
    Katelyn West,Project01,Question01,Yes,1
    Katelyn West,Project01,Question02,No,0
    Katelyn West,Project01,Question03,No,0
    Katelyn West,Project01,Question04,No,0
    Katelyn West,Project01,Question05,Yes,1
    Katelyn West,Project01,Question06,Yes,1
    Katelyn West,Project01,Question07,No,0
    Katelyn West,Project01,Question08,Yes,1
    Katelyn West,Project01,Question09,Yes,1
    Katelyn West,Project01,Question10,Yes,1
    Katelyn West,Project02,Question01,No,0
    Katelyn West,Project02,Question02,No,0
    Katelyn West,Project02,Question03,No,0
    Katelyn West,Project02,Question04,No,0
    Katelyn West,Project02,Question05,No,0
    Katelyn West,Project02,Question06,Yes,1
    Katelyn West,Project02,Question07,No,0
    Katelyn West,Project02,Question08,Yes,1
    Katelyn West,Project02,Question09,Yes,1
    Katelyn West,Project02,Question10,Yes,1
    Katelyn West,Project03,Question01,Yes,1
    Katelyn West,Project03,Question02,No,0
    Katelyn West,Project03,Question03,Yes,1
    Katelyn West,Project03,Question04,No,0
    Katelyn West,Project03,Question05,Yes,1
    Katelyn West,Project03,Question06,No,0
    Katelyn West,Project03,Question07,Yes,1
    Katelyn West,Project03,Question08,Yes,1
    Katelyn West,Project03,Question09,No,0
    Katelyn West,Project03,Question10,No,0
    Katelyn West,Project04,Question01,No,0
    Katelyn West,Project04,Question02,No,0
    Katelyn West,Project04,Question03,No,0
    Katelyn West,Project04,Question04,No,0
    Katelyn West,Project04,Question05,No,0
    Katelyn West,Project04,Question06,No,0
    Katelyn West,Project04,Question07,No,0
    Katelyn West,Project04,Question08,Yes,1
    Katelyn West,Project04,Question09,No,0
    Katelyn West,Project04,Question10,Yes,1
    Katelyn West,Project05,Question01,Yes,1
    Katelyn West,Project05,Question02,No,0
    Katelyn West,Project05,Question03,Yes,1
    Katelyn West,Project05,Question04,No,0
    Katelyn West,Project05,Question05,No,0
    Katelyn West,Project05,Question06,Yes,1
    Katelyn West,Project05,Question07,Yes,1
    Katelyn West,Project05,Question08,No,0
    Katelyn West,Project05,Question09,No,0
    Katelyn West,Project05,Question10,No,0
    Eliana Garcia,Project01,Question01,Yes,1
    Eliana Garcia,Project01,Question02,No,0
    Eliana Garcia,Project01,Question03,Yes,1
    Eliana Garcia,Project01,Question04,Yes,1
    Eliana Garcia,Project01,Question05,No,0
    Eliana Garcia,Project01,Question06,No,0
    Eliana Garcia,Project01,Question07,Yes,1
    Eliana Garcia,Project01,Question08,No,0
    Eliana Garcia,Project01,Question09,No,0
    Eliana Garcia,Project01,Question10,Yes,1
    Eliana Garcia,Project02,Question01,Yes,1
    Eliana Garcia,Project02,Question02,No,0
    Eliana Garcia,Project02,Question03,No,0
    Eliana Garcia,Project02,Question04,Yes,1
    Eliana Garcia,Project02,Question05,Yes,1
    Eliana Garcia,Project02,Question06,Yes,1
    Eliana Garcia,Project02,Question07,No,0
    Eliana Garcia,Project02,Question08,Yes,1
    Eliana Garcia,Project02,Question09,Yes,1
    Eliana Garcia,Project02,Question10,Yes,1
    Eliana Garcia,Project03,Question01,Yes,1
    Eliana Garcia,Project03,Question02,No,0
    Eliana Garcia,Project03,Question03,No,0
    Eliana Garcia,Project03,Question04,No,0
    Eliana Garcia,Project03,Question05,Yes,1
    Eliana Garcia,Project03,Question06,Yes,1
    Eliana Garcia,Project03,Question07,No,0
    Eliana Garcia,Project03,Question08,Yes,1
    Eliana Garcia,Project03,Question09,Yes,1
    Eliana Garcia,Project03,Question10,No,0
    Eliana Garcia,Project04,Question01,Yes,1
    Eliana Garcia,Project04,Question02,Yes,1
    Eliana Garcia,Project04,Question03,No,0
    Eliana Garcia,Project04,Question04,Yes,1
    Eliana Garcia,Project04,Question05,No,0
    Eliana Garcia,Project04,Question06,Yes,1
    Eliana Garcia,Project04,Question07,No,0
    Eliana Garcia,Project04,Question08,Yes,1
    Eliana Garcia,Project04,Question09,Yes,1
    Eliana Garcia,Project04,Question10,Yes,1
    Eliana Garcia,Project05,Question01,No,0
    Eliana Garcia,Project05,Question02,Yes,1
    Eliana Garcia,Project05,Question03,No,0
    Eliana Garcia,Project05,Question04,No,0
    Eliana Garcia,Project05,Question05,No,0
    Eliana Garcia,Project05,Question06,Yes,1
    Eliana Garcia,Project05,Question07,No,0
    Eliana Garcia,Project05,Question08,Yes,1
    Eliana Garcia,Project05,Question09,No,0
    Eliana Garcia,Project05,Question10,No,0
    McKenzie Evans,Project01,Question01,No,0
    McKenzie Evans,Project01,Question02,No,0
    McKenzie Evans,Project01,Question03,No,0
    McKenzie Evans,Project01,Question04,Yes,1
    McKenzie Evans,Project01,Question05,No,0
    McKenzie Evans,Project01,Question06,Yes,1
    McKenzie Evans,Project01,Question07,No,0
    McKenzie Evans,Project01,Question08,Yes,1
    McKenzie Evans,Project01,Question09,No,0
    McKenzie Evans,Project01,Question10,No,0
    McKenzie Evans,Project02,Question01,Yes,1
    McKenzie Evans,Project02,Question02,Yes,1
    McKenzie Evans,Project02,Question03,No,0
    McKenzie Evans,Project02,Question04,Yes,1
    McKenzie Evans,Project02,Question05,No,0
    McKenzie Evans,Project02,Question06,Yes,1
    McKenzie Evans,Project02,Question07,Yes,1
    McKenzie Evans,Project02,Question08,No,0
    McKenzie Evans,Project02,Question09,Yes,1
    McKenzie Evans,Project02,Question10,No,0
    McKenzie Evans,Project03,Question01,No,0
    McKenzie Evans,Project03,Question02,No,0
    McKenzie Evans,Project03,Question03,Yes,1
    McKenzie Evans,Project03,Question04,No,0
    McKenzie Evans,Project03,Question05,No,0
    McKenzie Evans,Project03,Question06,Yes,1
    McKenzie Evans,Project03,Question07,No,0
    McKenzie Evans,Project03,Question08,Yes,1
    McKenzie Evans,Project03,Question09,No,0
    McKenzie Evans,Project03,Question10,Yes,1
    McKenzie Evans,Project04,Question01,Yes,1
    McKenzie Evans,Project04,Question02,No,0
    McKenzie Evans,Project04,Question03,Yes,1
    McKenzie Evans,Project04,Question04,No,0
    McKenzie Evans,Project04,Question05,No,0
    McKenzie Evans,Project04,Question06,No,0
    McKenzie Evans,Project04,Question07,Yes,1
    McKenzie Evans,Project04,Question08,Yes,1
    McKenzie Evans,Project04,Question09,Yes,1
    McKenzie Evans,Project04,Question10,No,0
    McKenzie Evans,Project05,Question01,Yes,1
    McKenzie Evans,Project05,Question02,No,0
    McKenzie Evans,Project05,Question03,No,0
    McKenzie Evans,Project05,Question04,No,0
    McKenzie Evans,Project05,Question05,Yes,1
    McKenzie Evans,Project05,Question06,Yes,1
    McKenzie Evans,Project05,Question07,No,0
    McKenzie Evans,Project05,Question08,Yes,1
    McKenzie Evans,Project05,Question09,Yes,1
    McKenzie Evans,Project05,Question10,Yes,1
    Blair Silva,Project01,Question01,Yes,1
    Blair Silva,Project01,Question02,No,0
    Blair Silva,Project01,Question03,No,0
    Blair Silva,Project01,Question04,Yes,1
    Blair Silva,Project01,Question05,Yes,1
    Blair Silva,Project01,Question06,No,0
    Blair Silva,Project01,Question07,No,0
    Blair Silva,Project01,Question08,No,0
    Blair Silva,Project01,Question09,Yes,1
    Blair Silva,Project01,Question10,No,0
    Blair Silva,Project02,Question01,Yes,1
    Blair Silva,Project02,Question02,Yes,1
    Blair Silva,Project02,Question03,No,0
    Blair Silva,Project02,Question04,Yes,1
    Blair Silva,Project02,Question05,No,0
    Blair Silva,Project02,Question06,Yes,1
    Blair Silva,Project02,Question07,No,0
    Blair Silva,Project02,Question08,No,0
    Blair Silva,Project02,Question09,Yes,1
    Blair Silva,Project02,Question10,Yes,1
    Blair Silva,Project03,Question01,Yes,1
    Blair Silva,Project03,Question02,No,0
    Blair Silva,Project03,Question03,No,0
    Blair Silva,Project03,Question04,No,0
    Blair Silva,Project03,Question05,No,0
    Blair Silva,Project03,Question06,No,0
    Blair Silva,Project03,Question07,Yes,1
    Blair Silva,Project03,Question08,Yes,1
    Blair Silva,Project03,Question09,No,0
    Blair Silva,Project03,Question10,Yes,1
    Blair Silva,Project04,Question01,Yes,1
    Blair Silva,Project04,Question02,No,0
    Blair Silva,Project04,Question03,Yes,1
    Blair Silva,Project04,Question04,No,0
    Blair Silva,Project04,Question05,Yes,1
    Blair Silva,Project04,Question06,Yes,1
    Blair Silva,Project04,Question07,No,0
    Blair Silva,Project04,Question08,No,0
    Blair Silva,Project04,Question09,No,0
    Blair Silva,Project04,Question10,Yes,1
    Blair Silva,Project05,Question01,Yes,1
    Blair Silva,Project05,Question02,Yes,1
    Blair Silva,Project05,Question03,Yes,1
    Blair Silva,Project05,Question04,Yes,1
    Blair Silva,Project05,Question05,No,0
    Blair Silva,Project05,Question06,No,0
    Blair Silva,Project05,Question07,Yes,1
    Blair Silva,Project05,Question08,Yes,1
    Blair Silva,Project05,Question09,Yes,1
    Blair Silva,Project05,Question10,Yes,1

     

    • Mariusz's avatar
      Mariusz
      Community Champion
      7 years ago

      Hi Ailteir 

      Count rows = 
VAR _no = CALCULATE( COUNTROWS( 'Table' ),  'Table'[Answer] = "No" ) 
VAR _all = CALCULATE( COUNTROWS( 'Table' ),  ALL( 'Table'[Answer] ) )
RETURN IF( _no = _all, _all )

      Please see the below.

      Best Regards,
      Mariusz

      If this post helps, then please consider Accepting it as the solution.

      Please feel free to connect with me.
      Mariusz Repczynski

       

      • Ailteir's avatar
        Ailteir
        Helper I
        7 years ago

        Mariusz,

         

        Seems good. Late in the morning here - 2am. I will confirm it a solution tomorrow.

         

        Regards