topic Re: problem with map title in Management & Governance

problem with map title

zied_ahmed1 — Fri, 05 Jan 2018 08:43:11 GMT

Hello I have this map and i would like when i select one or N department i have the % of the Docs:

I used this but it doesn't work :

=If(GetSelectedCount([DepartementsFR.Name])=0,'',[DepartementsFR.Name]&' : '&

Num(Count({<[DepartementsFR.Name]={"$(=Only([DepartementsFR.Name]))"}>}Docs)/Count(ALL Docs),'###0,00%'))

Re: problem with map title

Anonymous — Fri, 05 Jan 2018 10:50:27 GMT

I don't understand the additional ONLY statement when working out the percentage, you need the calculation to work against selected departments which would just be a standard Count(Docs) statement.

To get all selected values in the title you can use the GetFieldSelections() function.

Take a look expression below and example attached;

=If(GetSelectedCount([DepartementsFR.Name])=0,'',GetFieldSelections([DepartementsFR.Name])&' : '&

Num(Count(Docs)/Count(ALL Docs),'###0,00%'))

Re: problem with map title

zied_ahmed1 — Fri, 05 Jan 2018 10:59:24 GMT

Hello,

Thanks you for your time,

The problem is when i select all departments i have this :

I need to have 100 % ...

Re: problem with map title

Anonymous — Fri, 05 Jan 2018 11:07:27 GMT

I would take a look at the underlying data, are there Docs without a DepartmentFR.Name?

Try changing your ALL to TOTAL, this should ensure all Docs without a department are not taken into account;

=If(GetSelectedCount([DepartementsFR.Name])=0,'',GetFieldSelections([DepartementsFR.Name])&' : '&

Num(Count(Docs)/Count(TOTAL Docs),'###0,00%'))

Re: problem with map title

zied_ahmed1 — Fri, 05 Jan 2018 12:00:00 GMT

Hello,

I tried this me too but it doesn't work,it display 100%.

Re: problem with map title

zied_ahmed1 — Fri, 05 Jan 2018 12:03:41 GMT

omarbensalem‌ stalwar1‌ they could help us

Re: problem with map title

OmarBenSalem — Fri, 05 Jan 2018 12:06:47 GMT

create a text object; put as a measure:

GetSelectedCount([DepartementsFR.Name])

do not select anything, see what it shows;

then select :

one or 2 departements and see what it shows;

let this be our first test

Re: problem with map title

zied_ahmed1 — Fri, 05 Jan 2018 12:17:44 GMT

Re: problem with map title

OmarBenSalem — Fri, 05 Jan 2018 12:18:32 GMT

what if u do not select a thing?

Re: problem with map title

zied_ahmed1 — Fri, 05 Jan 2018 12:22:16 GMT

the result is 0

Re: problem with map title

OmarBenSalem — Fri, 05 Jan 2018 12:36:08 GMT

good :

now we'll be deleting the only part; because only would work only if u select only ONE value:

=If(GetSelectedCount([DepartementsFR.Name])=0,'',

concat(distinct [DepartementsFR.Name] &' : '& aggr(( Num(Count(Docs)/Count(total {1} Docs),'###0,00%')),[DepartementsFR.Name]),',')

)

try sthing like this and tell me what happens

Re: problem with map title

zied_ahmed1 — Fri, 05 Jan 2018 12:40:26 GMT

It gives 0,01 for all departments :

Re: problem with map title

OmarBenSalem — Fri, 05 Jan 2018 12:42:35 GMT

Select only AUBE

Re: problem with map title

zied_ahmed1 — Fri, 05 Jan 2018 12:44:35 GMT

I checked one more time and i have this :

Re: problem with map title

OmarBenSalem — Fri, 05 Jan 2018 12:46:21 GMT

PLEASE SELECT JUST RHONE

Re: problem with map title

zied_ahmed1 — Fri, 05 Jan 2018 12:49:57 GMT

Re: problem with map title

OmarBenSalem — Fri, 05 Jan 2018 12:51:39 GMT

if u create a simple text chart,

put as expression :

Num(Count(Docs)/Count(total {1} Docs),'###0,00%'))

and then select RHONE

what do u have?

Re: problem with map title

zied_ahmed1 — Fri, 05 Jan 2018 12:54:28 GMT

0,09%

Re: problem with map title

OmarBenSalem — Fri, 05 Jan 2018 12:55:08 GMT

it's good then.

U can close the thread by marking every one of my answers as helpful and the best one as correct

Re: problem with map title

OmarBenSalem — Fri, 05 Jan 2018 12:55:36 GMT

and ps: if u ever want to see a higher percentage, try to select a country that is colord in red..