Skip to main content

I need to display the date (MONTH YEAR format) in my tooltip, but I'm not able to because I just get an asterisk. I do not have any data blends occurring, so I'm not sure what the cause is.

 

Can somebody help me create a calculated field as a workaround?

 

Thank you in advance.

4 answers
  1. Jul 28, 2016, 12:55 PM

    Hi Erin,

     

    David provided a great example on how to fix that issue. Here is breakdown of your options so you can better understand the issue.

     

    Cause:

    Dimensions are added to the tooltip using the ATTR aggregation. The asterisk is actually a visual indicator of a special type of Null value that occurs when there are multiple members that apply to the mark.

    Option 1:

    Add the dimensions of the field you want to display to Detail.

    Option 2:

    Use the dimensions elsewhere in the view to ensure that the marks are at the same level of detail.

    Option 3:

    The following instructions can be reviewed in the attached workbook.

    1. Create a string list with a calculated field using the
      PREVIOUS_VALUE
      function.
    2. Add this field to the tooltip.

     

    Hopefully this helps and let me know if you need anything else!

     

    Best,

    Nick

0/9000