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.
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.
- Create a string list with a calculated field using the
PREVIOUS_VALUE
function. - Add this field to the tooltip.
Hopefully this helps and let me know if you need anything else!
Best,
Nick
- Create a string list with a calculated field using the