Conditional style for workitems with comment count above average in RRDI
Hello,
I would like to create the conditional style in the report displaying in a different color workitems with higher number of comments by average. I know how to explicitly specify number of comments to be displayed in different color using numeric range style.
But I would like RRDI automatically calculate current average number of comments from this project area and apply it in the style.When I create following condition in my style
[Query1].[Comment Count] > [Query1].[Average(Comment Count)]
but I get then following error message when running the report:
The following expression is not valid: [Query1].[Comment Count] > [Query1].[Average(Comment Count)]. If the item exists in a query but is not referenced in the layout, add it to a property list. CRX-API-0005 An error ocurred at or near the position '27'. The variable named '[Query1].[Average(Comment Count)]' is invalid.
I would like to create the conditional style in the report displaying in a different color workitems with higher number of comments by average. I know how to explicitly specify number of comments to be displayed in different color using numeric range style.
But I would like RRDI automatically calculate current average number of comments from this project area and apply it in the style.When I create following condition in my style
[Query1].[Comment Count] > [Query1].[Average(Comment Count)]
but I get then following error message when running the report:
The following expression is not valid: [Query1].[Comment Count] > [Query1].[Average(Comment Count)]. If the item exists in a query but is not referenced in the layout, add it to a property list. CRX-API-0005 An error ocurred at or near the position '27'. The variable named '[Query1].[Average(Comment Count)]' is invalid.