Forms Pro Survey reporting

Ailteir — Thu, 08 Aug 2019 05:44:43 GMT

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.

Re: Forms Pro Survey reporting

Mariusz — Thu, 08 Aug 2019 07:34:14 GMT

Hi Ailteir

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

Best Regards,
Mariusz

Please feel free to connect with me.

Re: Forms Pro Survey reporting

Ailteir — Thu, 08 Aug 2019 07:38:27 GMT

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

Re: Forms Pro Survey reporting

Ailteir — Thu, 08 Aug 2019 10:29:06 GMT

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

Re: Forms Pro Survey reporting

Mariusz — Thu, 08 Aug 2019 13:21:35 GMT

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.

Re: Forms Pro Survey reporting

Ailteir — Thu, 08 Aug 2019 14:24:11 GMT

Mariusz,

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

Regards

Re: Forms Pro Survey reporting

Ailteir — Fri, 09 Aug 2019 02:53:12 GMT

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

Re: Forms Pro Survey reporting

Mariusz — Fri, 09 Aug 2019 07:20:59 GMT

Hi Ailteir

Do you need something like below?

Best Regards,
Mariusz

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

Please feel free to connect with me.

Re: Forms Pro Survey reporting

Ailteir — Tue, 13 Aug 2019 10:12:31 GMT

Mariusz,

Apologies I took an alternative using a query.

Reagrds

topic Re: Forms Pro Survey reporting in DAX Commands and Tips

Forms Pro Survey reporting

Re: Forms Pro Survey reporting

Re: Forms Pro Survey reporting

Re: Forms Pro Survey reporting

Re: Forms Pro Survey reporting

Re: Forms Pro Survey reporting

Re: Forms Pro Survey reporting

Re: Forms Pro Survey reporting

Re: Forms Pro Survey reporting