SAS VA Hover Labels - Replacing (missing) with NA

[macambo1]

The business users are getting confused when the Hover labels display (missing). This happens when there is no data for that specific series. Is there a way to either replace the (missing) with NA or to not show that series at all in the hover label.

Thanks,

Madeline

[Madelyn_SAS]

What is the object?

[macambo1]

This is an issue with line chart and bar chart objects within the report. 

Best,

Madeline

[Sam_SAS]

The easiest solution is probably just to hide the missing values. Create a filter on the Filters tab, and then deselect the "Include missing values" option on the filter.

Another approach, if the data item with missing values is a category, would be to create a calculated item with an expression like this:

IF ( 'Category'n Missing )
RETURN 'NA'
ELSE 'Category'n

Actually, you could use a similar expression for a measure by returning zero. This is probably bad practice if you are presenting data for something like a scientific study, so consider whether or not this is OK to do.

[macambo1]

So this is a data tips issue not a data issue. I want to be able to hide (missing) in the hover labels. I've attached an example of a hover label where for three of the series it says (missing). It should either not display these series in the label or it should say NA instead of (missing). Is there a way to do that?

Thanks,

Madeline