Forum Discussion
Transpose Table Without "Transpose" Button in Query Editor
Hello Anonymous
Using a Matrix visual, with your dates on the columns, go to Values > Show on rows and turn it on.
Is that what you are wanting to do?
Super UserHello Anonymous
Using a Matrix visual, with your dates on the columns, go to Values > Show on rows and turn it on.
Is that what you are wanting to do?
Hi jdbuchanan71 I'm not particularly looking for row labels. My issue is that in the matrix visual, I am able to format the dates as columns as in your visual. However, I am only able to show the very first row of values. If I choose another observation to add to "Values," the column for each date seems to split horizontally so two observations are associated with one date. Here is an example of what I get when adding another observation to "Values" in a matrix.
Instead of the "num" and "cl" values being side by side, I would like for them to be stacked on top of each other so "num" and "cl" are separate row entries.
- jdbuchanan71
If you swtich Values to show on rows, does that not work?
Aha jdbuchanan71 yes switching "show on rows" does, in fact, do what I want. My apologies -- I only attempted to "show on rows" with one observation in "Values" instead of the multiple values that I want to display. Thank you very much!
Hi, Can you please help me in sorting the monthyear in this matrix ??
