Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
In a bar chart, I have a 2 dimensions
a type which contains 2 valus and a dimendion of weeks which I modify as such:
=if( [VDate (Semaine)] > '$(vMaxSemaine_12)' and WeekName([VDate ]) <= '$(vMaxSemaine_1)',
if(len([VDate (Semaine)])=1, 'S0'&[Vente Date (Semaine)],'S'&[Vente Date (Semaine)]))
Then I have an indicator to calculate the %
(Count ( distinct {< [VDate (année)]={$(=vMaxAnneeVente )} >} [ID_BON] )
- Count ( distinct {<[ [VDate (année)]={$(=vMaxAnneeVente )}>} [ID BON] )
)
/ (Count ( distinct {<[FL_Vente] ={1} , [VDate (année)]={$(=vMaxAnneeVente )} >} total <[VDate (Semaine)]> [ID BON] )
- Count ( distinct {< [VDate (année)]={$(=vMaxAnneeVente )}>} total <[VDate (Semaine)]> [ID BON] )
The variable vMaxSemaine_12 = =weekname(max([VDate]), -12)
The problem is that the pourcentage is divided on the total of weeks and not by week
the desired result is as such:
Can you give some advice please.
Thanks.
Hello,
You should use TOTAL function in your denominator.
Maybe like this count(distinct [ID BS (Souscription)] )/count(TOTAL [ID BS (Souscription)] )
or
count(distinct [ID BS (Souscription)] )/count(TOTAL<Semaine> [ID BS (Souscription)] )
Regards,
Hello,
thanks for your reply, I'm already using TOTAL <[VDate (semaine)]> but it does not work.
Regards,