topic Re: SAS VA Hover Labels - Replacing (missing) with NA in SAS Visual Analytics

SAS VA Hover Labels - Replacing (missing) with NA

macambo1 — Thu, 03 Jan 2019 14:09:42 GMT

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

Re: SAS VA Hover Labels - Replacing (missing) with NA

Madelyn_SAS — Tue, 08 Jan 2019 14:23:02 GMT

What is the object?

Re: SAS VA Hover Labels - Replacing (missing) with NA

macambo1 — Tue, 08 Jan 2019 14:27:31 GMT

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

Best,

Madeline

Re: SAS VA Hover Labels - Replacing (missing) with NA

Sam_SAS — Tue, 08 Jan 2019 20:44:55 GMT

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.

Re: SAS VA Hover Labels - Replacing (missing) with NA

macambo1 — Wed, 09 Jan 2019 13:28:42 GMT

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