User Profile
Gowmadrid82
Frequent Visitor
Joined 4 years ago
User Widgets
Contributions
Re: Bar chart to show form responses for multiple users
Thank you Ashish and Ibendin for your suggestions. I have had a look at the custom visuals and whilst they can use both data points, visually I don't believe it will present the data that the user wants. I have managed to get the data as I want (to a certain degree by adding attribute and value to the x-axis (see below) with the legend showing as the associate Ashish_Mathur - I have tried your solution and using the slicer could work and I will present this to the requestor as an option. Although I do think they will prefer to have the quetsions separated out rather than the responses using the legend to present the questions as it is hard to digest the questions they have answered. Below is how your suggestion looks What I might do is have the attribute and value as the x-axis and then the count of value as the y. Remove the Legend completely (otherwise I cannot colour code the yes as green, no as red etc...) and then use the slicer as you suggested to view based on associate. (see below) If I do that, will I need to create a measure to apply the conditional formatting to show yes as green, no as red, no basis to respond as amber?Bar chart to show form responses for multiple users
Hi, I am collecting feedback responses from Microsoft Forms and storing those into SharePoint and would like to report on those using a bar chart. The questions are mainly 'yes', 'no' or 'no basis to respond' answers, except the last question which has Excellent, Good, Satisfactory etc... There will be multiple responses for the same user, for example x number of people may provide feedback for the same person. Each question in the form is a column in a table. I have unpivoted all columns with the exception of the column that contains the person receiving feedback. I am able to create a bar chart that shows each question and the number of responses by the person receiving the feedback (there will be 4 in total), although I am struggling to figure out how to show how whether they answered 'yes', 'no' or 'no basis to respond' for each question and for each person receiving feedback. Below is a table showing the data, the first column is the summer associate receiving the feedback, the second is the attribute showing the question and the last is the value whether it is 'yes', 'no' or 'no basis to respond'. I have used a clustered bar chart, set the x-axis as the attribute, the y-axis as the value and the legend as the summer associate. Any ideas on best way to get the visual to also show the actual value e.g. 'yes', 'no' or 'no basis to respond'? Rather than it just counting the number of rows for each questionMatrix with Clustered Bar Chart
Hi all, I am trying to replicate the visual below to show the average for questions answered and then to show the frequency of those ratings e.g. how many times did someone rate the number 5 for that particular question I have tried to replicate it but struggling. Is there a way of combining the visuals as above? I have so far created the visuals below Any ideas? thank youRe: Bar Graph with 3 topics showing average and last result
That is great, thank you. Yes, the highest ID being the last result. So I have nearly created what you have provided How do I get them to show as bars in the graph and not a line across it. What have you done differently for that? It is hard to follow your exact steps as it is in a different language. So I have the following
