5 Replies Latest reply on May 15, 2018 1:54 AM by sudheer.kumar.5

    Help to create Hostogram

    sudheer.kumar.5

      Hello,

       

      I need your help to create the histogram for the below data.

       

       

      VisitorAdultsChildrenInfantInfant on seat
      V11000
      V22101
      V31210
      V42002
      V53111
      V62010
      V73000
      V85004
      V91410
      V103000
      V111400
      V122000
      V133111
      V142010
      V153000
      V165004
      V171410
      V183000

       

      Trying to create the histogram to answer how many visitors made a search with how many travelers (total number of travelers)?

       

      Please help me.

       

      S

        • 1. Re: Help to create Hostogram
          Jeremy Calloud

          Hi,

           

          Please find attached two versions of your histogram. One where the different categories are stacked (combined results for Adults, Infants, ...) and another sheet with one histogram per category.

          To create the bin, I have used the Create > Bin > Size = 1 path.

          To be able to stack the categories, I have used the pivot tool in the data pane.

           

          Edit: added 10.5 version

           

          Hope it helps,
          J

          • 2. Re: Help to create Hostogram
            sudheer.kumar.5

            Hello Jeremy,

             

            Thank you for the quick help.

             

            Can you please attach the 10.5 version. I don't have 2018 version installed.

             

            S

            • 3. Re: Help to create Hostogram
              Jeremy Calloud

              I have added the 10.5 version in my other reply

              • 4. Re: Help to create Hostogram
                sudheer.kumar.5

                Hello Jeremy,

                 

                Thank you for the reply.

                 

                This is not something I am looking for. I would like to draw a histogram with the number of travelers customer has searched something like below:

                 

                1 Customer searched for 1 travelers (here I am referring the total number of travelers may contain Adult or Child or... )

                1 Customers searched for 2 travelers (here I am referring the total number of travelers may contain Adult or Child or... )

                6 Customers searched for 3 travelers (here I am referring the total number of travelers may contain Adult or Child or... )

                3 Customer searched for 4 travelers (here I am referring the total number of travelers may contain Adult or Child or... )

                1 Customer searched for 5 travelers (here I am referring the total number of travelers may contain Adult or Child or... )

                4 Customer searched for 6 travelers (here I am referring the total number of travelers may contain Adult or Child or... )

                2 Customer searched for 9 travelers (here I am referring the total number of travelers may contain Adult or Child or... )

                 

                Please, someone, help me on this.

                 

                S

                • 5. Re: Help to create Hostogram
                  sudheer.kumar.5

                  Got the solution.

                   

                   

                  S

                  1 of 1 people found this helpful