Forum Discussion
Visualisation of Real Time Data through Forms
Hi Anonymous ,
I have a sample table like this.
1.
2.Unpivot the column
3. Remove the useless column.
4. Create a measure.
Number of selection = COUNT(Sheet6[Value])Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is currently being used as real-time data, so I have created my own data set in BI. Have selected the 'streaming dataset' option. Does that make sense?
Anonymous , I am not clear on the problem you are facing. In case you want to write back. refer -https://www.youtube.com/watch?v=LxuRzj0X348
Hi @amitchandak thanks for your help. I have atached my question here. As you can see, when I visualise it in a table, these are the response I get. When visualised in a bar graph it has put the responses together (so if a respondent has mentioned a stress being physical/mental, it has put them together. I would like one bar (section) for each stressor. So the graph will show that 2 respondents have selected physical health, 2 respondents have chosen family for e.g.
Hi Anonymous ,
I have a sample table like this.
1.
2.Unpivot the column
3. Remove the useless column.
4. Create a measure.
Number of selection = COUNT(Sheet6[Value])Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.