9 Replies Latest reply: Jul 4, 2018 9:40 AM by Olivier GAUTIER RSS

    Use the Box-Plot for time Analysis; Help required.

    omar bensalem

      Hi all ( mto , stalwar1 ),

      I've never used the Box Plot chart and was wondering if anyone could help me with it please

       

      In fact, what my client wants is Time Analysis to know how much time his clients would take to do their first publication / candidature / service since the creation of their account.

       

      To do such a thing:

      I created the Nb_Of_Days to do each thing in the script (publication / candidature / service)

      Then I used for each:

      1) a bar chart (classification of 10 slots)

      2) an Histogramme with 10 Bars (to have a detailed view by day in each selection)

       

      Capture.PNG

       

      Now, the question is :  I was wondering if this was possible to include in a Box Plot Chart (all the 3 axis)

       

      sthing like this (excuse the horrible "art" of mine )

       

      Capture.PNG

       

      Thank u very much for ur expected help

        • Re: Use the Box-Plot for time Analysis; Help required.
          Olivier GAUTIER

          hi,

           

          but why not a stacked bar ?

          in dimension :

           

          publication/candidature/service

          ceil(nb_of-days/10)*10

           

          in expression :

          count()

           

           

          boxplot is more usefull for fractile

           

          regards

            • Re: Use the Box-Plot for time Analysis; Help required.
              omar bensalem

              Thank u for ur answer Olivier.

               

              I don't have any dimension that regroups publication/candidature/service

              nor have I one nb_of_days field

               

              In fact, I have date_creation, date_publication, date_candidature, date_service

              and based on that I calculate nb_of_Days_publication , nb_of_Days_Candidature, nb_of_Days_Tampon


              That said, I can't figure out a way to use ur method with a stacked bar

               

              As I said; what I was doing is sthing like this:

               

              in the bar chart  : (for publication)

              as dimension:

               

              if(Nb_deJours_Publication>=0 and Nb_deJours_Publication<10, '< 10 jours',

              if(Nb_deJours_Publication>=10 and Nb_deJours_Publication<20, '< 20 jours',

              if(Nb_deJours_Publication>=20 and Nb_deJours_Publication<30, '< 30 jours',

              if(Nb_deJours_Publication>=30 and Nb_deJours_Publication<40, '< 40 jours',

              if(Nb_deJours_Publication>=40 and Nb_deJours_Publication<50, '< 50 jours',

              if(Nb_deJours_Publication>=50 and Nb_deJours_Publication<60, '< 60 jours',

              if(Nb_deJours_Publication>=60 and Nb_deJours_Publication<70, '< 70 jours',

              if(Nb_deJours_Publication>=70 and Nb_deJours_Publication<80, '< 80 jours',

              if(Nb_deJours_Publication>=80 and Nb_deJours_Publication<90, '< 90 jours',

              if(Nb_deJours_Publication>=90 and Nb_deJours_Publication<100,'< 100 jours',

              if(Nb_deJours_Publication>=100 , '> 100 jours')))))))))))

               

              as a measure:

              count(ID_Compte)

               

              to have this:

              Capture.PNG

               

              and an histogramme as follow :

              dimension:

              Nb_deJours_Publication


              to have this:

              Capture.PNG


              This process is then repeated for the candidature and service:

              Capture.PNG



              Which means, that I have to include the COUNT(ID) as a measure to build my time analysis around and find a way to regroup all  of the axis in one chart..


              Ps: the BoxPlot was the demand of the client; far from being mine