8 Replies Latest reply: Mar 13, 2018 11:18 PM by Raju Kannuri

# Dimension as legend for multi expression

I need to show the dimensions as my legend values. It is working when i am having only one expression but with more than one, the expression value is coming as legend rather than dimension values.

Sample is attached. Any help would be appreciated.

Thanks.

• ###### Re: Dimension as legend for multi expression

Hello,

Try this.

• ###### Re: Dimension as legend for multi expression

Thanks Vamsee, but the given idea is not working. It is still showing the expression value in the legends.

• ###### Re: Dimension as legend for multi expression

Hi Suresh,

u can click on chartproperties---> Expressions ---> click on Expression as Legend

• ###### Re: Dimension as legend for multi expression

I need to show dimension as my legend and not expression.

• ###### Re: Dimension as legend for multi expression

Hi,

• ###### Re: Dimension as legend for multi expression

I need to show dimension as my legend. I am not understanding what you are saying.

• ###### Re: Dimension as legend for multi expression

Hi Suresh,

One solution for your  requirement is to create cyclic expression group.

Expression tab-> Select both expression -> click on group.

In the chart: Use the expression cycle in the bottom left to change between both expression.

Regards,

Binu

• ###### Re: Dimension as legend for multi expression

I think your scenario it won't work.

1. If you have one expression, second dimension shows as legend.

2. One dimension, you have to take 2 expressions with different attributes, if you have different measures it won't work.

One dimension as Date and 2 expressions

Sum({<Name={'Name1'}>}Requested)  label as Name1

Sum({<Name={'Name2'}>}Requested) label as Name2.   these shows as legend (Name1 and Name2)

OR

otherwise create Cyclic Group, based on Date and Name dimensions.

OR

This can be possible in Scatter Chart.

LegendTest:

Date, Name, Requested, Approved

2018-01-01, Name1, 250, 150

2018-02-02, Name1, 450, 350

2018-02-02, Name2, 150, 250

2018-01-01, Name2, 50, 100               // New added

];

But this works Total based. (X and Y axis)