Can you mock up a visual of what you're hoping to visualize? I'm not sure exactly what you're after based on the text alone -- it may just be another set of measures with a table calc for difference, but I'm not 100% clear on what you'd like to see in the viz. The dimensions are super important when considering table calcs, so if you want to do something at the level of "order", the "order id" or "order date" dimension may need to be in view.
I hope this helps -- happy analyzing!
Hey Matt, thanks for taking interest.
I have actually settled for calculating the initial data set with sql for now - dashboard was needed asap.
I basically iterate thru dates, calculate difference with orders from same client on previous day via FULL OUTER JOIN, thus getting differences, including cases when I need to compare 0 orders on some day (missing row) to . Then in Tableau I can sum positive values, negative values, calculate net value, etc.
Would still appreciate learning a way to acheive that with Tableau, if possible, from raw dataset containing daily orders with missing rows for days when there were none.
Current version looks like that: