Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    You could try using a matrix visualization and put both Date and Value in Columns (Date on top).

    • Anonymous's avatar
      Anonymous
      Not 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's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity 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.