Override Chart Axis Labels

[#1]

Is there a way to override the axis (X,Y) labels on a Bar Chart? At the moment the labels default to the value of the dimension used.

I would like to substitute another value but can't see how this might be accomplished.

[#2]

When you select dimension you can set the label name. Its to the right of the popup screen and called "Settings for selected dimension" or something like that. There you can check "label" and type in your prefered text.

[#3]

Or did you mean that you want to change all values displayed on the axis to something else? If that's the case I would just create a new field in the script with the corresponding values that I want to display based on the "real" dimension.

/Fredrik

[#4]

Not quite what I wanted. The 'Settings for Selected Dimension' options allow me to change the Title of the Axis but not the individual Axis (legend) values. These are coming from the Dimension.

Here is the problem;

The data values are system, catalogue, score

App1 - 2 - 90

App1 - 5 - 91

App1 - 6 - 94

App2 - 2 - 89

At the moment the catalogue is the dimension and so individual axis labels are 2, 5, 6, 2.

So the resulting bargraph has 4 bars and the values are 90, 91, 94, 89

I just want the axis labels to be App1, App1, App1, App2 and not 2, 5, 6, 2

[#5]

Hmm. I don't know how to deal with the fact that QV would group all App1 entries as one bar.

You get half the way by setting the dimension to App1 & '-' & catalogue but then of course the legend would be App1-2, App1-5 etcetera which might look ugly.

[Oleg_Troyansky]

You can use a calculated dimension using function Dual:

Dual(Text, Number)

The Text will be displayed on the axis, but the Number will be used for aggregation, etc... This should do what you wanted.

good luck!

Oleg

[Anonymous]

Speaking of dual - how QV will handle the situation with the same text (App1) but different numbers?

[Oleg_Troyansky]

I did a quick test and what I found was - you see the same label several times, but separate chart points, which is exactly what was required. So, the text is used for the labels and the number is used for determining the chart points.

[yblake]

This is really a perfect trick... but it's definitely an ergonomy fall ! assuming that users are human beeing, i would try to avoid that. If this is what they want after all, make sure this is not a application for a nuclear plant 😉

[#10]

Oleg,

Thanks very much. This works perfectly.

It isn't for a nuclear plant so we should be OK.

T