Hi all,
I have a chart I'm making in SSRS.
My database is returning data like this:
Period Name, Question, Answer, Count, Mean, Median
Nov 09, Can Haz Chezbrgr, Yes, 5, 4, 3.1
Nov 09, Can Haz Chezbrgr, No, 3, 4, 3.1
Nov 09, Can Haz Chezbrgr, DK, 2, 4, 3.1
Period Name is the primary grouping, question is the same for all rows. Answer varies as does count. The mean and median are calculated based on period name & count, but are the same for all values in each period.
I have a chart in SSRS that's plotting the Answers by period. I'm trying to add the mean as a single plotted item. The problem is that the mean text is showing up once for each answer in the legend, but only once in the chart (this makes sense since the values are all the same.
Here is an example chart:
Here is what my report definition looks like:
Ideally, I'd like to have only one entry in the legend for Mean, with no association to the answer. Is this possible?
Thanks for your help!