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?
.. | chart sum(January), sum(February), sum(March), sum(April), sum(May) by Activity | untable Month Activity Data | xyseries Activity Month Data