PieCharts!

0 Answers 47 Views
Report Designer (standalone)
Deasun
Top achievements
Rank 1
Veteran
Deasun asked on 21 Sep 2021, 05:26 PM

I have a dataset coming back:

Group      GrpAmt

PArent    $10.00

Standard $5.00

2 columns and 2 rows come back. Should this be formatted another way?

I have attached to the chart object but I am not getting the expected pie pieces.

Instead I get 2 round circles within each other. Not the doughnut version, changed to that and just got an extra white circle in the center.

How do I get the chart to show me the pieces?

 

 

Deasun
Top achievements
Rank 1
Veteran
commented on 21 Sep 2021, 06:01 PM

hmm

I added a 3 row of data and I now have 3 pie pieces, but! their equal sizes within the pie.

even though the amts are quite different.

1 says its 9.59%, another says 42.51% and the 3rd says 47.90%

But the pie pieces show up as 1/3 in size!!!

I expected the 1st to be a tiny piece and the other two to be major pieces.

What am I doing wrong?

Neli
Telerik team
commented on 24 Sep 2021, 11:49 AM

Hi Deasun,

I attached a sample report that contains a PieChart. It was created through the Wizard in the following way:

Series: Group

Values: Parent

Then you may want to change the DataPointLabel property of the barSeries to:

= Fields.Group + ": $" + Fields.Parent

Deasun
Top achievements
Rank 1
Veteran
commented on 05 Oct 2021, 07:33 PM

What does the DataPointLabel have to do with the pie piece's sizes ?

See each pie piece is exactly the same size!

They should be in relation to the % amt.

So the 58.50% should nearly take up 60% of the whole piechart.

Sorry if i am asking dumb ?'s first time playing with this chart.

Deasun
Top achievements
Rank 1
Veteran
commented on 07 Oct 2021, 03:27 PM

The way your piechart looks is what I want mine to look like. But as you can see from above image mine does not.

How can I get the sections to match up to their % value of the whole?

 

Deasun
Top achievements
Rank 1
Veteran
commented on 07 Oct 2021, 03:44 PM

It appears my issue was with the Series.barseries1.X property.

I had it set to: Count(Fields.SubGroup), which now makes sense as to way they were all one size. duh!

I reset it to: Fields.GrpAmt and it kinda worked.

It appears a negative bucket was given it a further problem. I only seemed to see half the PieChart.

I took that negative amt out from the datasource and the piechart worked!! :)

 

Whats the negative amount do that messes it up?

Neli
Telerik team
commented on 08 Oct 2021, 02:42 PM

Hi Deasun,

If  I understood correctly, there were some negative values in the datasource, is that correct? 

In this case, I would recommend using a column or line chart, where the negative values can be presented below the horizontal axis.

In order to avoid such issues, you can edit the expression of series' X value, which will return 0 if the current sum is a negative number:
= IIF(Sum(Fields.Value) < 0, 0, Sum(Fields.Value))

Note that having a negative number in the data set will affect the calculation of the other grouping members.

No answers yet. Maybe you can help?

Tags
Report Designer (standalone)
Asked by
Deasun
Top achievements
Rank 1
Veteran
Share this question
or