
1. Re: Segmented Histogram
Yuriy Fal Aug 15, 2016 5:38 AM (in response to sandra cuentas)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

Sample_YF.twbx 9.8 MB


2. Re: Segmented Histogram
sandra cuentas Aug 16, 2016 10:39 AM (in response to Yuriy Fal)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 Aug 17, 2016 8:12 AM (in response to sandra cuentas)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 Aug 17, 2016 11:04 AM (in response to Yuriy Fal)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 Aug 17, 2016 12:08 PM (in response to sandra cuentas)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 Aug 21, 2016 3:35 AM (in response to sandra cuentas)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

Sample3_YF.twbx 1.9 MB


7. Re: Segmented Histogram
sandra cuentas Aug 21, 2016 9:11 AM (in response to Yuriy Fal)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 Aug 21, 2016 11:39 AM (in response to sandra cuentas)Hi sandra,
Please find the attached.
Yours,
Yuri

Sample3_mod_YF.twbx 1.9 MB


9. Re: Segmented Histogram
sandra cuentas Aug 21, 2016 2:19 PM (in response to Yuriy Fal)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.