Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

create a graph to show differences between two graphs/data sets

I have recently created a survey and now creating a report to analyze the results and visualize it for top management.   I have one question with simple yes or no answers and a pie chart to show th...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi, Anonymous 

Yes, I think you do need to add other measures to calculate the count, if possible please provide sample data for research.

Best Regards,
Community Support Team _ Eason

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi v-easonf-msft 

 

of course sample data set is like this, bot columns have same number of rows(users) as this is a survey.

 

column1          column2

yes                     yes

yes                     yes

yes                     yes

yes                     no

no                      no

 

so when i put these in two different pie charts I see that first column1 chart has %80 yes and %20 no and column2 is %60 yes and %40 no.

 

what I would like to calculate  is the difference of yes counts to show that 80% of people know about the tool but %60 of them knows how to use it so we have %20 missing training on how to use the tool. 

 

thanks for your help and regards