Forum Discussion

Ailteir's avatar
Ailteir
Icon for Helper I rankHelper 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"...
Ailteir's avatar
Ailteir
Icon for Helper I rankHelper I
7 years ago

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

Ailteir's avatar
Ailteir
Icon for Helper I rankHelper 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
    Icon for Community Champion rankCommunity 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
      Icon for Helper I rankHelper I
      7 years ago

      Mariusz,

       

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

       

      Regards

      • Ailteir's avatar
        Ailteir
        Icon for Helper I rankHelper I
        7 years ago

        Mariusz,

        Thx have mocked it up. Nearly there it produces this using standard table visual.

        I would like to show as seperately as per second graphic. For example from the extract in the table the card graphic I propose would record 2 projects having all respondents answering "No" to  Question02.

         

        Regards

        Table visualDesired card based visual