Pivot your data. Have multiple rows per order. You'll have x-many rows for an order, where X is the number of rules applied. For each rule row, have the results in that row.
Thank you Joe. How would I setup/control the "X rows per order" as you mentioned?
Would it be possible to convert my Example file into Packaged Workbook, so I could follow?
Thanks again for providing the examples, I can use this in certain instances.
My example was representative of a much larger data source ( ~500,000 records).
If it wasn't possible to have multiple rows per order (i.e. a one order per row restriction), what would the Tableau solution work around look like? Apologies for not mentioning previously.
1 of 1 people found this helpful
Probably you would have everything calc-field driven, with (in your example) 4 levels of IF logic (and maybe 24: (4x3x2x1)) to handle all the permutations in those calcs. (And if you could have 5 rules, or 6, etc., it would grow in complexity accordingly.)
Don't do that to yourself.
Tableau is made to SING with data in the proper shape. Don't worry about 2 million records.
With data in the proper shape, I whipped up that example in 5 minutes. It took me longer to hack up the excel sheet than to write the tableau viz. (And maybe someone better versed in excel could have done that with some pivot function in just a few keystrokes!)
I had actually tried to create a variation of what you described, and it wasn't pretty. And the underlying DB has up to 15 such rules per order, so you've validated my results of exploring that path.
I agree, Tableau is awesome if the data in the right shape, so I'll work on re-shaping it.
Appreciate the help!