9 Replies Latest reply on Aug 21, 2016 2:19 PM by sandra cuentas

    Segmented Histogram

    sandra cuentas

      Dear Community,

       

       

      I hope someone can help me out with this one. I have attached the tbwx file generated with Tableau Desktop to demonstrate what I am trying to accomplish. Is there a way to remove Fechahora from the viz so i don't get a segmented histogram in worksheet 2? I haven't been able to do it as the time-related calculated filter depends on it.

       

      Thanks in advance.

        • 1. Re: Segmented Histogram
          Yuriy Fal

          Hi sandra,

           

          First, there's no way to remove [Fechahora] from the view,

          since your Table Calculation filter is referring to this field.

          Moreover, changing your LOOKUP() calc to something else

          (not a Table Calc variant) in not an option.

           

          What you're trying to achieve is to calculate an aggregate SUM(1)

          after applying your Table Calculation filter, which is not possible.

          Tableau works the way that any Table Calcs occur later in a pipeline --

          and Table Calc filters to apply after that (at the very last stage).

           

          To accommodate this, one could sync both the Table Calculation

          and it's (corresponding) TC Filter -- via Parameter, of course.

           

          Please find the attached as an example of such a technique.

          Hope it could help.

           

          Yours,

          Yuri

          1 of 1 people found this helpful
          • 2. Re: Segmented Histogram
            sandra cuentas

            Hi Yuriy,

             

            Thank you very much for your time, effort and kindness to help me with the question. Your solution effectively does the trick! However, I'm struggling to incorporate it to my main objective, so hopefully you could help me once again. I have attached another tbwx file where you can see the whole analysis. The bar chart you helped me with corresponds to what is shown in worksheet 1 but my main goal is to summarize what is shown in worksheets 1,2,3 into two bar charts corresponding to worksheets 4,5. I have succesfully summarized information given in worksheets 2, 3 into worksheets 4,5. But, i haven't had luck with incoporating the information given in worksheet 1 along with the others.

             

            Thank you again.

            • 3. Re: Segmented Histogram
              Yuriy Fal

              Hi sandra,

               

              I have attached another tbwx file where you can see the whole analysis.

              What file do you mean?

              If it is that one called Sample2.twbx in your original post,

              the extract in it doesn't include all fields from your MySQL datasource.

              Please upload the correct file (again) for me to help.

               

              Yours,

              Yuri

              • 4. Re: Segmented Histogram
                sandra cuentas

                Hi Yuri,

                 

                I'm so sorry about that. I made another extract, so hopefully now you have access to all fields (Sample3).

                 

                Thank you and sorry for the inconvenience.

                • 5. Re: Segmented Histogram
                  Yuriy Fal

                  Hi Sandra,

                   

                  Unfortunately, there are missing fields in Sample3.twbx, too.

                  You could see -- they're marked with a Red exclamation point.

                   

                  Yours,

                  Yuri

                  • 6. Re: Segmented Histogram
                    Yuriy Fal

                    Hi sandra,

                     

                    I'm sorry, I've overlooked the simple date format error,

                    which is easy to correct. No problem with your workbook.

                     

                    I am not sure that I understand the aim of your analysis,

                    so I've done something similar (with minimal efforts from my side)

                    of what found on sheets 4 and 5 of yours.

                     

                    Please find the attached.

                    If I miss, please reply.

                     

                    Yours,

                    Yuri

                    1 of 1 people found this helpful
                    • 7. Re: Segmented Histogram
                      sandra cuentas

                      Hi Yuriy,

                       

                      I'm so glad you found a solution for the workbook problem, my file did not show any red exclamation points so i was trying to solve the problem a little bit in the dark .  I thank you again for your help and feedback.

                       

                      I will explain the aim of my analysis with two examples so you can have a better idea of what i'm trying to accomplish:

                       

                      1. Mtc: 1529

                       

                      Sheet 1: 450 480 390   //(Partial Sum: 1320, Partial Count: 3)

                      Sheet 2: 1277 //(Partial Sum: 1277, Partial Count: 1)

                      Sheet 3: 0       //(Partial Sum: 0, Partial Count: 0)

                       

                      Summarizing in 4 and 5:

                       

                      Sheet 4 : 2597

                      Sheet 5: 4

                       

                      2. Mtc: 3070

                       

                      Sheet 1: 630 1174   //(Partial Sum: 1804, Partial Count: 2)

                      Sheet 2: 0 //(Partial Sum: 0, Partial Count: 0)

                      Sheet 3: 329       //(Partial Sum: 329, Partial Count: 1)

                       

                      Summarizing in 4 and 5:

                       

                      Sheet 4 : 2133

                      Sheet 5: 3

                       

                      I hope it helps.  I really appreciate your time and effort to help me out.

                      • 8. Re: Segmented Histogram
                        Yuriy Fal

                        Hi sandra,

                         

                        Please find the attached.

                         

                        Yours,

                        Yuri

                        1 of 1 people found this helpful
                        • 9. Re: Segmented Histogram
                          sandra cuentas

                          Hi Yuri,

                           

                          Fantastic! I am extremely thankful for your help, that's exactly what i was trying to accomplish  . I'm working on understanding the table calcs  associated with your solution.

                           

                          Regards,

                           

                          Sandra.