Forms Pro Survey reporting

Question

&nbsp;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" to by all respondents. For example in the attached pivot if Question02 were "Is there an agreed budget for the project" then there are 2 project where all respondents agree there is no budget.

mariusz · Answer

Hi&nbsp;Ailteir&nbsp;&nbsp;Can you provide the data sample you base your pivot on?Best Regards,MariuszPlease feel free to connect with me.&nbsp;

ailteir · Answer

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

ailteir · Answer

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

mariusz · Answer

Hi&nbsp;Ailteir&nbsp;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,MariuszIf this post helps, then please consider Accepting it as the solution.Please feel free to connect with me.&nbsp;

ailteir · Answer

Mariusz,&nbsp;Seems good. Late in the morning here - 2am. I will confirm it a solution tomorrow.&nbsp;Regards

Forum Discussion

Forms Pro Survey reporting

8 Replies

Related content

Survey data from Microsoft form

Automate report from MS Form survey

Data Model for Forms Survey data

Data Days Forms Broken?

Importing Survey Monkey data