We have some users how would like to visualize responses (values 1 to 5) from a survey in a graph. Together with the average response value they would also like to be able to see how many responses (count) have been received for the question.

So basically show the questions on X and average response value on Y + information about number of responses (count) on Y. I know this can be achieved with e.g. a combination of a bar graph for the average response and a line graph for the count. But our users would ideally like to only have the average response shown in a bar graph and the count shown as a text (could be on the axis, on the “bar” or above the “bar”). Any ideas how this can be accomplished using Targit?

Basically how to show a second measure as a text/label instead of a visual object.

I’ve tried to visualize what I’m trying to accomplish in a pictures. It’s the blue text (response count) that I don’t know how to show in Targit.



We are using Targit 2K13 and Analysis Services 2012.

Thanks for the suggestion. Clever workaround.

The problem is that my white/invisible measure have much higher values compared to the primary/visible measure so Targit will just show tiny bars at the bottom of the graph and then some floating labels at the top.

/Martin