Legends values

[sibusiso90]

Hi All,

I am trying to get legend values in the correct place. I don't have any dimension they are all expressions.

Is this possible though.

E.G
I currently have the below

My result is below

[Or]

Select the chart, hold down CTRL+SHIFT, and drag the legend where you want it.

[sibusiso90]

I don't want to move the legends I want them to appear as they would if I had a dimension

[felipedl · Accepted solution]

Hi Sibusiso,

Do the following,

as for the dimension, use the following code:

=Valuelist('Sale','AVG','MAX')

and for expression do:

=pick

(

    match

    (

          Valuelist('Sale','AVG','MAX'),

          'Sale','AVG','MAX'

),

//Expression for sale

sum(Sales),

//Expression for AVG

avg(Sales),

// Expression for max

max(Sales)

)

As an example, i've loaded this:

load * Inline

[

Sales

1

2

3

4

5

6

7

8

9

10

];

And got the following with the mentioned expression and dimension:

Attached the file I used