Thank you for your reply.
nope. what I want is for example,
OrderID count is 1 for ship date 1/8/2009 and order date 1/8/2009 but has no value for 1/2/2009 till ship date is 1/8/2009.
I want the value 1 for order date 1/8/2009 and ship date 1/2/2009. i.e. count is shifted to first value of shipdate.
similarly, order ID count which is 1 for ship date 1/9/2009 should be moved to first column . then find the running sum of count table across.
if you find the date on the left and match it up to the same date across the top, that would be your date 1.
Then you would build from there, being your date 2, date 3, etc.
Let me know if this makes sense.
Not exactly. I am not sure if we can even do this in tableau. My client wants to see the value same for left column and top column.
i.e. OrderID count is 1 for ship date 1/8/2009 and order date 1/8/2009.
my client wants to see the value 1 for order date 1/8/2009 and same value instead at ship date 1/8/2009 , value should be displayed at ship date 1/2/2009
similarly for 1/9/2009 and other dates.
I have attached the Sample data(this data set is not from super store data).
There are two tabs
1. Current tab is what we have now.
2. Expected Tab is what we want.
So If you see in current tab, value 11 is for created date and discharged date 1/8/2017.
But It should be displayed as mentioned in Expected tab.
i.e. value 11 is now shifted to left most column for 1/8/2017.Similarly for all the dates .
Can we achieve this in tableau?
Sample Data.xlsx 18.3 KB
Don't you have original data as well in excel?
yes, i want something like this.
But In my example workbook I had countd(orderid) as my measure.
if i have countd(orderid) ,then I cannot have lookup(min([countd(orderid)]),[Index]-1) because min and countd both are aggregations.
That's not a big problem, just as same concept.
Could you mark my answer as correct, if your issue is fixed to close the thread..
It's not from inbox view, but from original post.