i5PieChart issue - unable to display value column value

[former_member477229]

Hi,

I am trying to generate i5Pie chart with a query template which return below data

. The query returns

     quantity confirmed

     quantity pending

     Quantity in work.

I have mapped this column as value columns , but the piechart is not getting generated.

Its just display one complete circle.

However when I look at the raw data on chart , i can see the correct values.

In addition to this , the chart is generated using the applet based piechart.

Attaching the configuration and Pichart screenshot which I am getting when i use Ui5 chart.

We are using xMII 15.

Will appreciate quick help.

Regards

Vishal Jadhav

[swaroop_anasane · Accepted solution]

Dear Vishal,

The structure of your data is not as expected by Pie chart.

It has to be something like

Col1(Quanity in your case)     Type

Value1                                   In Queue

Value2                                   In Work

Value3                                   Completed

And "Col1" should be mapped to Pie chart's value columns and "Type" as label column so that you get 4 pies' in the chart with specific span. Please note, Pie chart should trend of a single type of value over no. of rows present.

Also, it's not xMII any more.

Hope this helps.

Warm Regards,

Swaroop

[swaroop_anasane]

HI Vishal,

There isn't much difference when it comes to a specific type of chart. Pie chart expects one columns only whatever be the case.

Anyways, good that we could help.

Regards,

Swaroop

[Private_Member_14935]

Hi Vishal,

You should try out Swaroop's suggestion. The pie sectors that get shown is only for the values in the first column selected in ValueColumns, irrespective of the number of columns you may have added in ValueColumns. (i.e Even if you have multiple columns in ValueColumns only the first one will be considered and the total no.of sectors in the pie chart will be equal to the number of records returned by the query).

Hope this helps!

Thanks and Best Regards,

Ria

[former_member477229]

Thanks Swaroop and Ria.

I was able to get the chats as per the solution given by you..

I dont know why they they have different data format for Applet chart and UI5 chart.

Now we need to tune the queries to get columns in row format.

Appreciate your help guys.

Vishal Jadhav