Scott Waye
Top achievements
Rank 2
Iron
Veteran
Iron
Rank 2
Iron
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
0
Accepted
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:
In the above example, the result of the Exec function will be the sum of the values for each category.
Regards,
Katia
Progress Telerik
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
Iron
Veteran
Iron
Rank 2
Iron
Veteran
Iron
answered on 03 Apr 2018, 09:07 PM
Thanks, dont know why I didn't see that.