Trying to change x-axis label on chart based on key

[#1]

So basically I want a chart that follows the x axis but for x axis labels I need it to say the product associated with the axis:

The axis needs to follow x but the labels should be advocacy where x is 54, 59.5 and 65. Task Force at 27, 46, 65, etc

Thanks!

[MarcoWedel]

Calculated Dimension:

Aggr(Product1, X)

[#3]

“No Numeric Value on X axis” is what it tells me.

[JonnyPoole]

perhaps you have a continuous X axis enabled on the presentation tab  ?

personally i'm not sure, i'd like to see a QVW sample.

[#5]

I got rid of the continuous axis and that error doesn't show up but all my data points are pooling in one area and it shows null for x while aggr my product1 with it. I wish I could show you the qvd but the data is rather sensitive. I'm doing an associative curve chart.

[JonnyPoole]

can you screenshot the result without the yaxis ?  a qvw would still help

[MarcoWedel · Accepted solution]

Hi,

one solution could be:

using

=Dual(Product1, X)

rather than

=Aggr(Product1, X)

hope this helps

regards

Marco

[#8]

I actually figured this out myself yesterday! But I will give you the correct answer anyway! Thank you

[#9]

Now if there was a way I could use a continuous X axis so things don't look so skewed!...