1 2 Previous Next 19 Replies Latest reply on Mar 12, 2019 6:03 PM by Anand Bale

    Histogram

    Gowthami Sathiyanathan

      Hi Friends

       

      I am learning Tableau to get Tableau certification and faced a below question. I don't have idea to solve the below question, please guide me.

       

      Using Global Superstore, Creating histogram of 1000's for Sales, which bin has the maximum overall Profits by Region?

       

      My Approach

       

      1. Sales(bin) of 1000 in Column shelf . And count of Sales in Row shelf. Histogram view get created.

      2. Dragged sum(profits) to tooltip, to get the profit.

       

      Don't understand how to archive the following "maximum overall Profits by Region"

       

      Regards

      Gow

        • 1. Re: Histogram
          Anand Bale

          Hi

           

          Please check this one. "maximum overall Profits by Region"

           

          1 of 1 people found this helpful
          • 2. Re: Histogram
            Gowthami Sathiyanathan

            Thank you Anand

             

            Btw, is it necessary to include Region to filter shelf?. Kindly clarify

             

            And please help me to validate my answers for below questions

             

            1. Plot a Box chart with Profit by Sub-Category  and identify the Region with maximum distribution.

             

            1.jpg

             

            2. Using Global Superstore, which state has average Ship time over 7days (Day difference between Order date and Ship date)?

             

            Add datediff > 7 in filter shelf on top of below view

             

            3.jpg

             

            3. Using Global Superstore, which state sub category has average Ship time over 7days (Day difference between Order date and Ship date)?

             

            4.jpg

            From grand total value, we can find the state whose value greater than 7

             

            4. Using Orders and Returns from Global Superstore, which Region had the highest Return % (Return as % of Total Sales) for Tables Sub-Category?

             

            5.jpg

             

             

            1 of 1 people found this helpful
            • 3. Re: Histogram
              Anand Bale

              Hi Gowthami,

               

              It is not necessary to include the region, just i added it for only filter purpose.

               

              It seems all your calculations are good and i have a suggestion for Calculation 3.

               

              3. Using Global Superstore, which state sub category has average Ship time over 7 days (Day difference between Order date and Ship date)?

               

              In Exam time is more important so please find attached twbx file to check the answer, let me know if it helps.

               

              Thank you

              1 of 1 people found this helpful
              • 4. Re: Histogram
                Gowthami Sathiyanathan

                Thank you so much  Anand

                 

                Errors occurred while trying to load the attached workbook as my Tableau public is  in older version. If possible can you please send the image of calculation 3.

                 

                In addition to above, can you please validate answers for below questions

                 

                1. Using Superstore, In which of the following regions the Subcategory Office Supplies has sales more than the Overall Average sales 

                 

                6.jpg

                 

                 

                2. Plot a Box chart with Profit by Region and identify the Sub-Category with maximum distribution.

                 

                7.jpg

                 

                3.  Find cumulative sales for customers who first purchased in 2012

                 

                8.jpg

                 

                4.  identify the Sub-Categories where Top 20 Customers that have Sales more than the other Sub-Categories in the same Region

                 

                5. Using SuperStore, identify the  office supply category where top 3 customers have negative profits along the region??(identify count of of negative profits)

                 

                Can you please help me, how to approach answers for above 2

                 

                Thanks in Advance

                Gowthami

                • 5. Re: Histogram
                  Anand Bale

                  Hi Gowthami,

                   

                  Please find attached screenshot for Question 4.

                   

                  i will answer question 5 soon, but which data source you want me to use????

                   

                   

                  Compute Using by Customer Name.

                   

                  Please let me know if it works.

                   

                  Thank you

                  • 6. Re: Histogram
                    Gowthami Sathiyanathan

                    Am i correct for other questions?

                     

                    You have answered question 5, For question 4, use the superstore data ,  identify the Sub-Categories where Top 20 Customers that have Sales more than the other Sub-Categories in the same Region

                     

                    And please provide screen shot for the below question

                     

                    Using Global Superstore, which state sub category has average Ship time over 7 days (Day difference between Order date and Ship date)?

                     

                    Thanks in Advance

                    Gowthami

                    • 7. Re: Histogram
                      Gowthami Sathiyanathan

                      Hi Anand

                       

                      For  Using SuperStore, identify the  office supply category where top 3

                      customers have negative profits along the region??(identify count of of

                      negative profits)w

                       

                      How to select top 3 for each region, when i add index to filter, it filter

                      top 3 overall by include all regions. PFA

                       

                      On Sat, 19 Jan 2019 at 06:17, Anand Bale <tableaucommunity@tableau.com>

                      • 8. Re: Histogram
                        Anand Bale

                        Hi

                         

                        Using Global Superstore, which state sub category has average Ship time over 7 days (Day difference between Order date and Ship date)?

                         

                        // Days duration  == DATEDIFF('day',[Order Date],[Ship Date])

                         

                         

                        //Calculation on filter:  No. of days == AVG([Days duration for shipping]) >= 7

                         

                         

                        Thank you

                        • 9. Re: Histogram
                          Gowthami Sathiyanathan

                          Thank you so much Anand.

                           

                          Hope rest of questions I have approached it correctly. If possible, please

                          try answer below question

                           

                          Using Global Superstore, identify the Sub-Categories where Top 20 Customers

                          that have Sales more than the other Sub-Categories in the same Region.

                           

                          On Sat, 19 Jan 2019 at 09:27, Anand Bale <tableaucommunity@tableau.com>

                          • 10. Re: Histogram
                            Gowthami Sathiyanathan

                            Hi Anand

                             

                            Can you please validate the answers for below

                             

                             

                             

                            1. Using Global Superstore, identify the Sub-Categories where Top 20 Customers that have Sales more than the other Sub-Categories in the same Region

                             

                            12.jpg

                             

                            2.Plot a Box chart with Profit by sub category and identify the region with maximum distribution.

                             

                            1.jpg

                            • 11. Re: Histogram
                              Anand Bale

                              Hi Gowthami,

                               

                              Both looks Good, that will be great  if you share your twbx file or tableau public links.

                               

                              Thank you

                              • 12. Re: Histogram
                                Gowthami Sathiyanathan

                                Thanks for the reply

                                 

                                Attached questions with answers. Each of 4 sheet title explains my

                                question. Please validate my answers

                                 

                                Regards

                                Gowthami

                                 

                                On Mon, 21 Jan 2019 at 20:26, Anand Bale <tableaucommunity@tableau.com>

                                • 13. Re: Histogram
                                  Anand Bale

                                  Hi

                                   

                                  Questions 1:

                                  as per my view, we should consider the count of order id, then we can find out the percentage of the returns.

                                   

                                  Question 2:

                                  You are right, Answer is None because there is no category meets with sales and projection.

                                   

                                  Question 3:

                                  It's a continuous dimension.

                                  here is the link: Continuous Dates - Tableau

                                   

                                  Good Luck.

                                  • 14. Re: Histogram
                                    Gowthami Sathiyanathan

                                    Thank you so much for the answers.

                                     

                                    Can you please validate below answers as well

                                     

                                    1)which of the following statement true

                                    a. New version of extract created in .hyper

                                    b. New version of extract created in .tde

                                    c. .hyper useful when there are huge number of records

                                    d. First time to create .hyper file needs more time

                                     

                                    To my knowledge a,c,d is correct. Please correct if iam wrong

                                     

                                    2)Which of the following datasources requires an extract only

                                    Salesforce was one of the option. Can you Please list what other

                                    datasources requires an extract

                                     

                                     

                                    3)Auto refresh happens

                                    a.Publishing on Tableau server

                                    b.Opening on Tableau online

                                     

                                    I hope that a is correct answer

                                     

                                    4.Plot a Box chart with Profit by Sub-Category  and identify the Region

                                    with maximum distribution.

                                    Method 1 :In view included   both sub category and region in pills. From

                                    the graph infer that East region having maxi distribution

                                     

                                     

                                    Method 2 :  :In view included   sub category in details marks card and

                                    region in pill. From the graph infer that Central region having maxi

                                    distribution

                                     

                                     

                                     

                                    I have used the Superstore dataset

                                     

                                    Thanks

                                    Gowthami

                                    1 2 Previous Next