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.
Sample_YF.twbx 9.8 MB
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.
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.
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.
Unfortunately, there are missing fields in Sample3.twbx, too.
You could see -- they're marked with a Red exclamation point.
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.
Sample3_YF.twbx 1.9 MB
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.
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.