How to change the dimension value name in the chart

[#1]

Hi, I was doing a check and got the below doubt. Could somebody help me on this?

I have two data sets for example as below kept in two tabs of the attached excel file. In the first tab, I have EmpID and Name. In the second tab, I have EmpID, Salary, and some other fields.

The issue is there are some EmpID whose name is not present but salary and other details are present. So, when I create a bar graph with Name as dimension and Sum(Salary) as expression, I got a dash symbol for the salary whose names are not there in my database. I want to change the dash symbol to some other word such as 'Unknown'. How to change it?

Please find the source data in two tabs of the Excel file and my chart as an image below.

[neelamsaroha157]

You can add if condition in your script as

If(isNull(Name) or Len(Name)<1, 'Unknown', Name) as NewNameField

[passionate · Accepted solution]

You can use calculated Dimension like attached:

[#4]

Hi Neelam,

Thanks for your reply. But the issue is in the Emp1 tab, there are no null values in Name field. There are less number of records. If there is null values, then the script you mentioned will help definitely.