topic Re: Set analysis problem ? in Francophones

Set analysis problem ?

Wed, 12 Mar 2014 09:54:01 GMT

Hello everyone.

I would like percentages rather than values. So I tried to use the TOTAL with function Count but it does not work.

Does anyone have an idea?

count (DISTINCT{$<date_entree={"<>0"}>} Matricule)

count (DISTINCT TOTAL {$<date_entree={"<>0"}>} Matricule)

Thanks in advance,

Emmanuelle

P.S. : My expression is found in the graph at the top right in the INPUT tab-output

Re: Set analysis problem ?

Wed, 12 Mar 2014 10:00:20 GMT

Emmanuelle

don't understand very well

check if it is what you want

christian

Re: Set analysis problem ?

Wed, 12 Mar 2014 10:01:52 GMT

If you want percentages rather than values, just write a normal simple expression and then check the "Relative" option. If that gives you weird numbers, instead add " & '%' " to the end of your expression.

Cheers,

Lucas

Re: Set analysis problem ?

er_mohit — Wed, 12 Mar 2014 10:12:54 GMT

See the attached file

try this

count (DISTINCT{$<date_entree={"<>0"}>} Matricule)

count (TOTAL<ANNEE_DATE_ENTREE> {$<date_entree={"<>0"}>} Matricule)

Re: Set analysis problem ?

Wed, 12 Mar 2014 10:13:18 GMT

I tried this too, but this is not quite right. I would like my total percentage for 2013 is equal to 100%, the same for 2014.

Is that possible to do that ?

Emmanuelle

Re: Re: Set analysis problem ?

Wed, 12 Mar 2014 10:22:24 GMT

Emmanuelle

here it is

christian

Re: Set analysis problem ?

Wed, 12 Mar 2014 10:24:26 GMT

Bonjour Emanuelle,

try this expression, the total is bounded to "ANNEE_DATE_ENTREE". Should work as expected.

count (DISTINCT{$<date_entree={"<>0"}>} Matricule)

count (DISTINCT TOTAL <ANNEE_DATE_ENTREE> {$<date_entree={"<>0"}>} Matricule)

Re: Set analysis problem ?

Wed, 12 Mar 2014 10:35:28 GMT

I have a small gap in 2013 but I know how to explain. That's perfect.

Thank you Roland and everybody for your help 🙂