This is a migrated thread and some comments may be shown as answers.

Show percentage as datapoint

2 Answers 420 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Scott Waye
Top achievements
Rank 2
Veteran
Iron
Scott Waye asked on 28 Mar 2018, 04:02 PM

In a stacked column graph (not the 100% one), is it possible to construct an expression that show the percentage of the amount of the series as expressed as a percentage of the total for the column, as per the attached?

Or do I have to do this in the SQL?

2 Answers, 1 is accepted

Sort by
0
Accepted
Katia
Telerik team
answered on 02 Apr 2018, 10:21 AM
Hello Scott,

The value of the data point label is controlled with DataPointLabel property of the series. This property can be set to an expression that calculates the percentage of each series in the total value for the current category, for example:
= Sum(Fields.Value) / Exec('categoryGroup', Sum(Fields.Value))

In the above example, the result of the Exec function will be the sum of the values for each category.

Regards,
Katia
Progress Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Scott Waye
Top achievements
Rank 2
Veteran
Iron
answered on 03 Apr 2018, 09:07 PM
Thanks, dont know why I didn't see that.
Tags
General Discussions
Asked by
Scott Waye
Top achievements
Rank 2
Veteran
Iron
Answers by
Katia
Telerik team
Scott Waye
Top achievements
Rank 2
Veteran
Iron
Share this question
or