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%'))
=If(GetSelectedCount([DepartementsFR.Name])=0,'',
GetFieldSelections([DepartementsFR.Name])&' : '& Num(Count(Docs)/Count(total {<[DepartementsFR.Name]>} Docs),'###0,00%')
)
the expression u're using?
this one :
=If(GetSelectedCount([DepartementsFR.Name])=0,'',
GetFieldSelections([DepartementsFR.Name])&' : '& Num(Count(Docs)/Count(total {<[DepartementsFR.Name]>} Docs),'###0,00%')
)
create 2 kpi objects:
1) count(Docs)
2) Count(total {<[DepartementsFR.Name]>} Docs)
at first don't select ANYTHING and tell me what numbers do u see? is it the same in both KPI
then select all departments, and see what happens
then select some departments and see what happens
if i don't select anything i have the same value
if i select all departments i have :
if i select two departments :
when u do not select anything, u have count(docs) = 1073... ??
you mean count (Docs)
Docs = dos_ref_externe this is just to simplify the name in the topic
when u do not select anything, u have count(docs) = 1073... ??
yes yes
what if u change this:
Count(total {<[DepartementsFR.Name]>} Docs)
to
aggr(Count(total {<[DepartementsFR.Name]>} Docs),[DepartementsFR.Name])