-
1. Re: Tooltip not working - ATTR seems to be the issue
lei.chen.0Jun 5, 2016 6:39 PM (in response to Jan Paulsen)
Hello Jan,
First I'd like to confirm your requirements.
- You want a bar graph showing the sum of value for category.
- You want sum of value for Germany and France showing in the tooltip.
If so, my solution would simply be,
[Tooltip Germany]: IIF([Country]="Germany",[Value],0)
[Tooltip France]: IIF([Country]="France",[Value],0)
Then drag them into Marks shelf.
You may notice that SUM is automatically added. That's all right.
Then include them in the tooltip.
As for ATTR, here's the description,
"Returns the value of the given expression if it only has a single value for all rows in the group, otherwise it displays an asterisk (*)"
In the bar graph, field country has multiple values, thus ATTR(Country) returns asterisk.
Regards
-
2. Re: Tooltip not working - ATTR seems to be the issue
Mahfooj Khan Jun 5, 2016 9:09 PM (in response to Jan Paulsen) -
3. Re: Tooltip not working - ATTR seems to be the issue
Jan Paulsen Jun 8, 2016 3:24 AM (in response to lei.chen.0)Thanks a lot, it works!!
-
4. Re: Tooltip not working - ATTR seems to be the issue
Jan Paulsen Jun 8, 2016 3:25 AM (in response to Mahfooj Khan)Ok, very simple;-) Thank you for the help!