How do I invert the x and y-axis in my chart?

[andrewtrobec]

Hello,

I'm trying to flip the x and y axis of a chart so that I can change the way my data is visualized. As it stands, the chart command generates the following table:

... | chart sum(January), sum(February), sum(March), sum(April), sum(May) by Activity

Activity,January,February,March,April,May
Running,31,63,35,54,1
Jumping,53,97,81,76,13
Crawling,64,13,81,105,36

What I'd like to do is be able to flip it so that the months (currently field names) become column values for a new column called "Month" and the activities become fields with and end result:

Month,Running,Jumping,Crawling
January,31,53,64
February,63,97,13
March,35,81,81
April,54,76,105
May,1,13,36

Is this at all possible?

Thank you!

Andrew

[sundareshr · Accepted solution]

Try this

.. | chart sum(January), sum(February), sum(March), sum(April), sum(May) by Activity | untable Month Activity Data | xyseries Activity Month Data

[jkat54]

Might also like "| transpose" although it requires renaming the columns.

[andrewtrobec]

Short and sweet, thank you so much!