I have a bubble chart on a report. The data source lists physicians, issues and counts. The size of the bubble is based on the Sum(IssuesFound).
Our client base is split between those with only a few issues and those with quite a few.
I am attempting to place a dynamic filter on the chart, so that a points are plotted when there are less than 8 but limit to points with larger bubbles when there are more than 8 bubbles. At Series > lineSeries2 > SeriesGroup > Filters I entered:
Expression: = Sum(Fields.IssuesFound)
Value: = IIf(CountDistinct(Fields.AuditIssueId) >= 8, 5, 0)
However, the results are that it always shows all items on the chart (the false result of the IIF).
I've added text boxes in the report header to show me the values of Sum(Fields.IssuesFound) and CountDistinct(Fields.AuditIssueId) and they are correct.
I suppose that the IIf is not evaluating properly during the chart rendering.
If I hard code the Values, like =5, the filter works great and only those issues with a count of 5 or more are plotted.
Is it possible to make this dynamic?