Pie Chart Reporting Modual

[jarrod.zabielski]

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.

[JordanCClark]

This should help you out. As an extra bit of information, the underlying dataset in a report query would be

data['keyname'].getCoreResults()

Transpose Rows and Columns

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…

[jarrod.zabielski]

Thanks Jordan, will see how we go.