Forum Discussion
Changing Axis(Flip X/Y Axis) on "Table" Visual
Hi Everybody,
Quick question here. I'm using the visualization "Table". It has a Date field and multiple values.
The Values of these columns, such as the acutal dates and actual values, go down vertically. The column headers are sprawled horizontally across the screen. Is there a way to reverse this? Here's what currently is on my table:
Date Value
1/1/16 1
1/2/16 2
1/3/16 3
Here is what I want:
Date 1/1/16 1/2/16 1/3/16
Value 1 2 3
Edit: I've looked through all of the settings under Fields and Format and couldn't find anything.
OK, hmm, I don't think you are going to get there with the out-of-the-box visuals and I did not find any custom visuals that would help. My only suggestion would be to use R to get you there and my R skillz are not world class. But, this link might help:
http://www.cyclismo.org/tutorial/R/tables.html
Let me know if this gets you there.
6 Replies
- Greg_Deckler
Community Champion
You could try using a matrix visualization and put both Date and Value in Columns (Date on top).
- AnonymousNot applicable
Hi smoupre,
Thank you for being helpful as always. I didn't mention that these values are Measurements. It seem that I can't drag them into any field except for Value.
Putting Date into Columns helped, but the issue now is that I can't put the Measurements into the Rows area.
- Greg_Deckler
Community Champion
OK, hmm, I don't think you are going to get there with the out-of-the-box visuals and I did not find any custom visuals that would help. My only suggestion would be to use R to get you there and my R skillz are not world class. But, this link might help:
http://www.cyclismo.org/tutorial/R/tables.html
Let me know if this gets you there.