Custom y-axis values

rutger_jansen — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm trying to produce a chart with string labels for the y-axis. The y-axis is currently numeric and is the result of a calculation.

Data is like this:

LOAD * INLINE [

Month, Class, Value

Jan, A, 200

Jan, B, 300

Jan, C, 200

Feb, A, 150

Feb, B, 100

Feb, C, 600

];

This is transformed as follows:

round( sum(if( Class='A',(1*Value), if( Class='B',(2*Value), 3*Value))) / sum(Value) )

To give these weighted values (this is what I have):

Jan, 2

Feb, 3

No I want to get to a chart showing:

Jan, B

Feb, C

I haven't been able to figure out if Dual() can be used for this.

Any help would be greatly appreciated

Regards

Rutger

Re: Custom y-axis values

sunny_talwar — Wed, 11 Apr 2018 15:24:38 GMT

Are you looking for something like this?

rutger_jansen — Wed, 11 Apr 2018 15:37:47 GMT

Hi Sunny,

Yes, it comes close but is it possible to get the Y-axis to show A, B, where it currently shows 1, 2 & 3?

Thanks very much,

Rutger