I do not understand what the data looks like when you get it. Which picture shows how things start out? If you are getting a string of text that is delimited in some way, we can make it do anything. Can you post a copy here for Forum readers to work with?
Thank you Tim,
Example above would be three tables as follows:
BATCH_ID Date 101 2018-08-01 10:00:00 102 2018-08-01 10:30:00
BATCH_REF INPUT WEIGHT 101 Nut 10 101 Bolt 10 101 Magic Bean 7 102 Nut 20 102 Bolt 18 102 Baked Bean 14
BATCH_REF OUTPUT WEIGHT 101 Unicorn 20 101 Pizza Cutter 300 102 Apple iPhone 8 4 102 Lollipop Sticks 700
In reality I have to jump through a number of hoops in SQL to get it into this kind of form.
But, I could also derive many other kinds of SQL output as required.
The bit i'm struggling with is how to represent this as required in Tableau.
Can you just do a WITH statement and LEFT JOINs to get it all into one?
Sent from the iPhone of Timothy Dines.
Yes, this will be the cartesian long form of the dataset. I can do this.
But how in tableau can I create the tabular view that I illustrated first?
Input Weight (kg)
Output Weight (kg)
Nut 10 101 Unicorn 20 Bolt 10 Pizza Cutter 300 Magic Bean 7 total weight in: 27kg total weight out: 320kg
The closest I can get to by using the cartesian long form is
so of course, I don't get any of the benefit of row totals etc.
Attached is my excel for this example, but for anybody reading this, I'm not 100% fixed to this input format - I can be flexible with SQL queries, joins and blending to achieve my desired output.
mimo1.xlsx 9.1 KB