How to get a percentage value when using grouping and an aggregator function

[Jonathan]

Hi there,

I'm using a RadChart to create some bar graphs of the total number of projecs per project type. I'm using a group descriptor to group the data:

<telerikCharting:SeriesMapping.GroupingSettings>
    <telerikCharting:GroupingSettings ShouldCreateSeriesForLastGroup="True">
        <telerikCharting:GroupingSettings.GroupDescriptors>
            <telerikCharting:ChartGroupDescriptor Member="ProjectType"/>
        </telerikCharting:GroupingSettings.GroupDescriptors>
    </telerikCharting:GroupingSettings>
</telerikCharting:SeriesMapping.GroupingSettings>

My item mappings looks like this:

<telerik:SeriesMapping.ItemMappings>
    <telerik:ItemMapping FieldName="ProjectType" DataPointMember="XCategory" />
    <telerik:ItemMapping FieldName="Name" DataPointMember="YValue" AggregateFunction="Count" />
</telerik:SeriesMapping.ItemMappings>

I'm attaching a screenshot showing what this currently looks like. What I want though, is to show the percentages of each category in addition to the number of projects. I don't know ahead of time how many project types will be included in the data being graphed.

I appreciate any help I can get with this.

Thanks,
Jonathan

[Peshito]

Hi Jonathan,

Simply use the ItemLabelFormat property of the SeriesDefinition like shown below:

<telerik:RadChart.SeriesMappings>
      <telerik:SeriesMapping>
          <telerik:SeriesMapping.SeriesDefinition>
              <telerik:BarSeriesDefinition ItemLabelFormat="#DATAITEM.Value %"/>
          </telerik:SeriesMapping.SeriesDefinition>
          <telerik:SeriesMapping.ItemMappings>
              <telerik:ItemMapping FieldName="Title" DataPointMember="XCategory" />
              <telerik:ItemMapping FieldName="Value2" DataPointMember="YValue" />
          </telerik:SeriesMapping.ItemMappings>
      </telerik:SeriesMapping>
  </telerik:RadChart.SeriesMappings>

The above code will just add the percentage sign to the item's value. You can use a custom or standard numeric format expression to further specify the format.

More about expressions can be found in our Format Expressions help topic.

Regards,
Peshito
Telerik