Compare Grouped Values

[BVZ]

Hello,

I have one series in column chart that is grouped by a certain field, so i get two columns per x-axis tick.

Now what i would like to do is to set the background of the second column to green if its column value is less than the value of the first colum. And to set the background to red if it is greater than the first column's value.

 

Is this possible in standalone designer?

 

See attached Image

 

Best regards

Benjamin

 

 

[Stef]

Hello Benjamine,

You can use the Series.DataPointConditionalFormatting to change colors based on data. For example check the attached demo report in the Standalone Report Designer of Telerik Reporting R2 2017.

There is a conditional formatting with the following rule based on data and the Exec data function that evaluates the expression in a specific scope:

Expression:
= Fields.ser='ser2'
And
Exec('catGroup',Sum(IIf(Fields.ser='ser1',Fields.val,0))) > Exec('catGroup',Sum(IIf(Fields.ser='ser2',Fields.val,0)))

Operator: =

Value: =True

'catGroup' is the name of the CategoryGroup of the series, the one that defines slots on the X axis.

Please note that this may lead to ambiguity due to the colors used in the legend. There is conditional formatting on Series.LegendItem.MarkerConditionalFormatting, but bars can still be colored differently.

Regards,
Stef
Telerik by Progress