Greetings. Even though I have been trying to use Tableau for 2 weeks now I still have very basic questions.
First off, my dataset has 160 columns that contain every piece of information about our assembly process... there is no other dataset, just a big jumbled mess of BS.
1. On sheet 1 I have filtered my data perfectly to represent the number of... R2D2 droids we have built. This sheet doesn't contain any calculations other than the measures auto-produced.
2. On sheet 2 I have filtered my data perfectly to represent the number of... Defects associated with all unique R2D2 serial numbers. This sheet doesn't contain any calculations other than the measures auto-produced.
Arriving at these number requires different filters, hence, the 2 different sheets. But how in name of Jesus' whiskey bottle does one take those to numbers and use them in a calculation?
# of R2D2's built / # of R2D2 defects = # of defects per R2D2 built.
I really want to convey how upset I am by using a lot of profanity... I hate Tableau! I hate it. This is so easy in Excel and Tableau seems to have turned something incredible easy into something convoluted. I want to take my number of machines I built and divide that by the number of defects. How much easier could this be? It's only 6:45am and I already hate my life today.
************Okay... so 40 views and no answers... let me give it to you a different way. Look at "Meeting1" attachment. I created 2 separate and basic SQL queries that sort of answer the above question. Problem is... my join is messed up. It doesn't seem to matter how I join the data, or what join clause I use, I always end up with NULL values (machines) when I start to compute my DPU by date. Year/Month. I believed this was the best way to compute my DPU in the beginning (pertaining to the above question), but I still cannot get the data to give me the output I need because the DPU is wrong (not computing the NULL values). Ideas?