7 Replies Latest reply on Nov 28, 2018 5:28 PM by lei.chen.0

Default Mark Annotation for Country (Group)

Sing Yan Ang Nov 27, 2018 5:38 PM

Hello all!

I am facing this problem:

- I grouped a few countries together (Malaysia, Cambodia, Myanmar, Egypt, Brunei, Laos) as Indochina

- When I add a mark annotation for that particular group, the default position it points to is Egypt and I can't change that

Any way that allows me to adjust the default position to Malaysia instead?

*Reason why I am using a mark annotation instead of a point/area annotation is because I need it to react dynamically to the filters selected

*Reason why I am not using labels is because they do not have lines/arrows

Thank you!

1. Re: Default Mark Annotation for Country (Group)

lei.chen.0 Nov 27, 2018 6:52 PM (in response to Sing Yan Ang)
Hello Sing Yan Ang,

I guess the point is set to the country with the largest area in the group.

A workaround is to use dual axis.

Sample workbook is attached.

Regards
Lei

Dual Axis.twbx 281.8 KB
Like Show 0 Likes(0)

Actions
2. Re: Default Mark Annotation for Country (Group)

Sing Yan Ang Nov 27, 2018 7:26 PM (in response to lei.chen.0)

Hello Lei,

Thanks for your reply!
Can I just check which field you used to display the sum of GDP for the country group?
Like Show 0 Likes(0)

Actions
3. Re: Default Mark Annotation for Country (Group)

lei.chen.0 Nov 27, 2018 8:07 PM (in response to Sing Yan Ang)

Hello Sing Yan Ang,

Please refer to the screenshot.

Regards
Lei
Like Show 0 Likes(0)

Actions
4. Re: Default Mark Annotation for Country (Group)

Sing Yan Ang Nov 27, 2018 8:59 PM (in response to lei.chen.0)

Hello Lei,

Thanks for the clarification. The method works when I only have Indochina shown in the view. If another country is added, the annotation shows a range of values instead of a single value for the country group.
Like Show 0 Likes(0)

Actions
5. Re: Default Mark Annotation for Country (Group)

lei.chen.0 Nov 27, 2018 9:35 PM (in response to Sing Yan Ang)

Hello Sing Yan Ang,

In general, I think it is possible to solve this by a calculation (maybe using LOD).

Please attach a sample workbook for suggestions about the calculation.

Regards
Lei
Like Show 0 Likes(0)

Actions
6. Re: Default Mark Annotation for Country (Group)

Sing Yan Ang Nov 27, 2018 11:46 PM (in response to lei.chen.0)

Hello Lei,

I did a LOD calculation: {FIXED Country (Group): SUM(Sales)}
But a problem with that is that this particular worksheet will not react to other worksheet filters when placed in the same dashboard. Hence, I decided to just stick with labels.

Thanks anyway!
Sing Yan
Like Show 0 Likes(0)

Actions
7. Re: Default Mark Annotation for Country (Group)

lei.chen.0 Nov 28, 2018 5:28 PM (in response to Sing Yan Ang)

Hello Sing Yan Ang,

Please have a try at adding the filters into context.
Sing Yan Ang wrote:

But a problem with that is that this particular worksheet will not react to other worksheet filters when placed in the same dashboard.

Regards
Lei
Like Show 0 Likes(0)

Actions