<null> always show on chart attribute

[former_member196805]

Hello,

  I found that the <null> value always show on chart attribute. I had modified the show measure to only the attribute but the <null> value is still there. I tried modify the excel dataset but still doesn't work.

  I am using Lumira Cloud.

  Please help...

BR

Chapman

[Henry_Banks]

Hi,

As discussed internally:

I would recommend to simplify the source excel file first:  as it is an export of a webi report, be sure to 'save for data', rather than 'retain formatting'. also preferring a flat table rather than a crosstab, and no titles or empty rows in the headers.

i would also advocate the use of lumira desktop client, to further manipulate the dataset before publishing to cloud. (as it is possible to append multiple .xls sheets, and merge source files etc. as well as filtering and data cleansing.)

Regards,
H

[Henry_Banks]

hi,

As you are an SAP employee, i'd recommend you ask this question in our internal site called "Enterprise Self Service Community"

that way we can collaborate and share datasets etc. email each other.

regards,

H