9 Replies Latest reply on Dec 4, 2017 2:00 PM by Shinichiro Murakami

# Displaying values in tirangle

Hi All,

I have a requirement from healthcare client where I have to show  running sum of COUNTD(Value) for Date of discharge and date of Value created on. This gives me a traingle.  Now, my client wants a variation in the report. COUNTD(Value) should be displayed for same Date of Discahrge date and Created Date.

I created  a traingle with ship date and Order date using Super store data .In Attached Worksheet for the date 1/8/2009, we see that COUNTD(Order) is null for all the ship dates untill it reached 1/8/2009. But I want to start the value from Order date  1/8/2009 .

i.e. for order date 1/8/2009 countd(Value) is 1 but this starts at ship date 1/8/2009. instead I want 1 to start from first ever value of the ship date  and then calculate the running sum .

similarly for all the dates.

I tried with this formula, lookup(countd(orderId)),first()). this doesn't work.

Can any1 of you help me with this?

TIA!

• ###### 1. Re: Displaying values in tirangle

I am not fully understanding your request, but if you need this logic,

If this is wrong, give us the exact example with the numbers.

Regards,

Shin

• ###### 2. Re: Displaying values in tirangle

Hi,

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.

• ###### 3. Re: Displaying values in tirangle

Hi Susheela,

Still not fully understand the needs ,but something like this?

I need Exact number of specific line items to understand your needs.

Regards,

Shin

• ###### 4. Re: Displaying values in tirangle

Hi,

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?

• ###### 5. Re: Displaying values in tirangle

Hi Susheela,

Don't you have original data as well in excel?

Regards,

Shin

• ###### 6. Re: Displaying values in tirangle

If the data top half is available in the format of

This way,

You can do it with below.

Regards,

Shin

• ###### 7. Re: Displaying values in tirangle

Hi,

I have attached revised tableau workbook and also Expected result.

Let me know if this makes sense .

thank you for all your help.

• ###### 8. Re: Displaying values in tirangle

Hi,

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.

• ###### 9. Re: Displaying values in tirangle

HI Susheela,

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.

Regards,

Shin