Assistance can be provided if you can provide sample data source that represent your situation, and a mock up of what you expect for a result from the sample data.
Thanks Joe et al.
I thought I could create sets and filter for top 1 per unique but its pretty confusing (AND Joe Mako says that n-filter KB page I used was not the best anymore).
And attached is the tableau packaged workbook. I needed to join the tables because I need to filter the sales channel to show what backorder is from which sales_channel. I hope this packaged workbook is sufficient, i hid some fields
You have hidden the important columns that would enable a solution. please unhide the fields used in the join and those that identify a distinct record.
I can not longer see the image from your earlier mess so I don't know if the attached is correct, you can see the dimension pills that I place on the Level of Detail shelf, and used as addressing for the table calc, those were my guess for what would create the values the you wanted to sum.
Book2 jm edit.twbx.zip 571.0 KB
Wanted to say thank you for your input and help first and foremost. I have a comparison with the original unjoined workbook and the joined tables and i see that there are small differences in the number of backorders..
Dec Jan Feb Mar Apr May Jun Avail 1 1 1 29 156 Hold 1 13 74 249 215 1104 351 No Stock 2 1 15 82 639 3118 Open 4 445 Partial 5 13 70 2630
and the original version without the table join
Dec Jan Feb Mar Apr May Jun Avail 1 1 1 29 156 Hold 1 13 74 249 215 1105 351 No Stock 2 1 15 82 653 3119 Open 4 447 Partial 5 13 71 2630
Do you know if this is just an artifact of the joining or is there a way to correct this error? I was wondering if you can direct me to some reading or videos so I dont take up more of your time. Thank you again Joe
can you supply an extract of the original before the join that generated these different numbers?
this forum has a wealth of content
as for taking up my time, participating on this forum is a joy for me. It is how I learn Tableau, and share knowledge. The more interesting questions you ask, the happier I am. I thank you for asking questions, they provide me with meaningful practice. Please keep the questions coming!
I've searched google and the forum for the problem i am having with the labels when adding information to the level of details. I got a result on the forum but it uses the SQL which i am not familiar with (http://community.tableau.com/thread/110581).
I was wondering if there is a simpler solution? And thank you for your help on this forum, I'm positive i am not the only one that would be lost without you and your postings.
I am not sure what you are showing there. and image is not enough in this case. Please supply the packaged workbook that creates this view, and detail what you expect for a result.
What combination of fields identifies a distinct record in bkoWOjoin?
In regards to this view, you somehow grouped the labels and showed the sum instead. I cant figure out how to do that.
In regards to what creates a unique record:
before i do the join, the numbers are perfect. Unfortunately i need to filter using sales channel so i need to create a join. After the join, i get an extra layer that includes the serial number which causes the value for bko to be included numerous times. The unique record would be order_no + part_number. An order can have multiple partnumbers associated with the order, but the serial number that gets factored in is just to show which serial number is designated to the order number.
> "The unique record would be order_no + part_number."
I am not seeing that. There is no field named "part_number".
The closet that I can resonable get to unique is the combination of:
but still that is not distinct, eg, two records for:
To remove the overlapping values, you likely need to set the compute using.
This thread has gone long enough, I think it is best if you email me
Can you finish your last thought on the post I'm replying to please?
"To remove the overlapping values, you likely need to set the compute using."