# Pie Chart Reporting Modual **URL:** \ **Category:** General Discussion\ **Created:** [May 28, 2018, 11:45pm UTC](https://forum.inductiveautomation.com/t/pie-chart-reporting-modual/18191 "2018-05-28T23:45:04Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![jarrod.zabielski](https://avatars.discourse-cdn.com/v4/letter/j/e99b99/32.png) [@jarrod.zabielski](https://forum.inductiveautomation.com/u/jarrod.zabielski)\ **Post date:** [May 28, 2018, 11:45pm UTC](https://forum.inductiveautomation.com/t/pie-chart-reporting-modual/18191/1 "2018-05-28T23:45:04Z")
Hello I want to use Pie chat in the reporting module. Query return results in following format. BL line CL line Keg line Office Ro 500 200 300 150 100 How can I transpose the query result, there is no ‘extract order’ property in the Pie Chart Reporting module that is an option in Pie chart in Designer In designer we have an option under the Data heading to Extract Order, by Column or by Row. This option is not available in the reporting pie chart that we can find. Our quire is complicated and not easy to change. ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [May 29, 2018, 11:28am UTC](https://forum.inductiveautomation.com/t/pie-chart-reporting-modual/18191/2 "2018-05-29T11:28:36Z")
This should help you out. As an extra bit of information, the underlying dataset in a report query would be ```auto data['keyname'].getCoreResults() ``` > [@Transpose Rows and Columns](http://forum.inductiveautomation.com/t/transpose-rows-and-columns/14308/2): > > I have something that could be massaged into what you need. The follow code is designed to take one or more datasets, each with a just a few rows, and flip all the rows into columns. Should be close to what you need: #---------- # Construct a dataset with columns from supplied datasets rows. The column # names from the first dataset become the string values in the first column # of the result. The first argument to the function is a sequence of names # for the dataset arguments. The name s… ---
**Author:** ![jarrod.zabielski](https://avatars.discourse-cdn.com/v4/letter/j/e99b99/32.png) [@jarrod.zabielski](https://forum.inductiveautomation.com/u/jarrod.zabielski)\ **Post date:** [June 1, 2018, 8:53am UTC](https://forum.inductiveautomation.com/t/pie-chart-reporting-modual/18191/3 "2018-06-01T08:53:20Z")
Thanks Jordan, will see how we go.