problem with map title

[zied_ahmed1]

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%'))

[OmarBenSalem]

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

[zied_ahmed1]

It gives 0,01 for all departments :

[OmarBenSalem]

Select only AUBE

[zied_ahmed1]

I checked one more time and i have this :

[OmarBenSalem]

PLEASE SELECT JUST RHONE

[zied_ahmed1]

[OmarBenSalem]

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?

[zied_ahmed1]

0,09%

[OmarBenSalem]

it's good then.

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

[OmarBenSalem]

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