Change name dimension in bar chart

[#1]

Hello everyone,

I need your help. Indeed, I want change a name to one dimension in bar chart :

I want change the name "-" in other name change color of the bar.

If you have any idea, tell me.

Thank you in advance.

Best regards

SD

[ogster1974]

To sort that out you have 2 choices

1. Click exclude null checkbox against your dimension which will remove it from your chart.

2 set a limitation on your dimension, fixed number (in your case 6) the rest of your values will then be shown as other.

Regards

Andy

[ahaahaaha]

Hi Salim,

As variant, may be, as in attached file. In this example, when loading the script, create an additional field X1. Next, in the chart, used X1 in place of X and adjust the color with the appropriate settings and expression. The color of the bar name could not change.

Regards,

Andrey

[viveksingh]

Hi Salim,

"-" is not name. the chart is holding null values. uncheck the "Show null values" option which will appear under the dimention.

[OmarBenSalem]

In your bar chart, under data, dimensions, uncheck this:

[vinieme12 · Accepted solution]

Change it to calculated Dimension

=IF(len(Fieldname)>0,Fieldname,'Others')

or preferably handle this during data load

example

LOAD

*,

IF(len(trim(Fieldname))>0,Fieldname,'Others') as Fieldname

From xxxx;

[#7]

Hello,

No, I want to display the value when my dimension is equals null(), but I would name this field if it was possible.

[#8]

Thank you, it's the answer that I looked !