Could you share your workbook in .tbwx format?
Good morning Rob
Agree with Norbert I would prefer to see the twbx workbook you are using
but the result you are describing sounds like your 2 (soon to be 3) files are at different levels of detail (eg one is record level data the other has been aggregated to header level data) - your header level data is repeated across each of the record level data and get multiplied during the aggregation process - so what to do
there are several approaches the could work - first in Tableau proper recognise when you are using header level data and use a Min(), Max(), or AVG() aggregation function vs sum() - a different approach would be to bring the files into Tableau Prep and use the Aggregation function there to bring your record level data to the same level as your header level and then join the files together - you could then output the file to Tableau Proper
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks guys. I have attached the two tbwx files. Ultimately, I am looking for a filled map with custom territories based on groups of 5 digit zips similar to this. (zip.tbwx file). This is really the definition of our territories. About 126 pods made with groupings of 5 digit zips. I created a separate workbook to play just with the map you see below. Except I want a heat map where the color of the territory is based on the number total of customer volume (from bid_line).
I am then looking to attached summary information on the shipments associated by orig-pod, dest_pod and eqp_type (defined in the data source left outer join.power lanes test.tbwx). You will see in power lanes test.tbwx my numbers are crazy high because of the left outer join. My highest numbers should be a couple hundred thousand, not 10M + Sounds like this is resolved with a different aggregation function as Jim suggests. I did play with a fixed function, but that either wasn't the right choice or I did it wrong. I will explore Jim's path on the aggregation function.
the files you sent do not have the data you need to extract the data and send as a twbx
Yeah, that would be helpful. I updated the files on my reply.