Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%'))
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
It gives 0,01 for all departments :
Select only AUBE
I checked one more time and i have this :
PLEASE SELECT JUST RHONE
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?
0,09%
it's good then.
U can close the thread by marking every one of my answers as helpful and the best one as correct
and ps: if u ever want to see a higher percentage, try to select a country that is colord in red..