Forum Discussion
Multiple variables on x axis? Stacked column visualization
Microsoft EmployeeHi Anonymous,
In Query Editor mode, please unpivot table to convert its structure to below format.
Place [Questions] onto X-axis and place [Answer] into legend of a stacked column chart.
Best regards,
Yuliana Gu
That looks good
I'll have to research this more as when I just unpivoted one column, my entire table is now showing Error for the values
DataSource.Error: We couldn't parse OData response result. Error: A value without a type name was found and no expected type is available. When the model is specified, each value in the payload must have a type which can be either specified in the payload, explicitly by the caller or implicitly inferred from the parent value.
So, I got it to work but now that it created multiple rows, it shows each person took the test multiple times instead of just once. Any way to get the non unpivot columns to only show a value once?
For example, if bob took 1 test with 30 questions, I need Bob to show only 1 test and not 30 tests. Hope this makes sense
Can I make a copy of the table, strip out everything but name, test date and the new unpivot column and value column then use that new table to get visualizations on the test questions? That way my other visualizations are not impacted?
- v-yulgu-msft
Hi Anonymous,
For example, if bob took 1 test with 30 questions, I need Bob to show only 1 test and not 30 tests. Hope this makes sense
Not very clear about your requirement. Does DISTINCTCOUNT meet your requirement? Please illustrate your scenario with some sample data.
Can I make a copy of the table, strip out everything but name, test date and the new unpivot column and value column then use that new table to get visualizations on the test questions? That way my other visualizations are not impacted?
Of course you can.
Regards,
Yuliana Gu
- v-yulgu-msft
So this has been working well for me but now my refresh times are taking an hour to complete and I'm thinking it's because of the duplicate tables being updated at the same time. Could that be a reason?