7 Replies Latest reply on Apr 18, 2017 7:15 AM by Steve Czap

How to get associating date for Max Value

Steve Czap Apr 17, 2017 2:05 PM

Hello Experts,

I have a formula that finds the max value of my variable nicely by using, WINDOW_MAX (Max([Select RowCnt or ElapsedSecs]))

I would like to capture the [Start Ts] date that corresponds with that max value above. I've tried using the If-then and Case formulas but cannot find the right syntax that Tableau accepts.

I'm looking for something like...

If WINDOW_MAX (Max([Select RowCnt or ElapsedSecs])) Then day([Start Ts])

Any assistance would greatly be appreciated.

Thank you,

Steve

1. Re: How to get associating date for Max Value

subodh Thapliyal Apr 17, 2017 2:19 PM (in response to Steve Czap)

Steve,

If you can please attach a sample workbook here or piece of dataset.

Subodh
Like Show 0 Likes(0)

Actions
2. Re: How to get associating date for Max Value

Steve Czap Apr 17, 2017 2:33 PM (in response to subodh Thapliyal)
Hi Subodh,

I attached a screenshot of the one graph I'm working on. I'm trying to incorporate this in the ToolTip as shown. In the WorkBook, I have all the graphs there and would like to have the user be able to hover over the bar for additional info.

I've also included a sample subset of the data that the graph utilizes.

Thank you
Steve

ETL_Data.xlsx 28.5 KB

ETL.png 123.6 KB
Like Show 0 Likes(0)

Actions
3. Re: How to get associating date for Max Value

Steve Czap Apr 17, 2017 2:35 PM (in response to Steve Czap)
Both attachments didn't upload....here's the data.

ETL_Data.xlsx 28.5 KB
Like Show 0 Likes(0)

Actions
4. Re: How to get associating date for Max Value

subodh Thapliyal Apr 17, 2017 3:19 PM (in response to Steve Czap)

HI Steve,

I was not able to use your calculation from the data you sent but able to achieve Max(datetime) across each value.
I guess that's what you were looking for.

Use this formula to get your max date across each Start TS.

Hope this helps.

Subodh
Like Show 0 Likes(0)

Actions
5. Re: How to get associating date for Max Value

Steve Czap Apr 17, 2017 4:09 PM (in response to subodh Thapliyal)

Thanks for the response, Subodh.

I created a variable based on your formula and placed it in my Tooltip but I get the date that corresponds to the barcode I hover over (the date changes when I change barcode). If you refer to my screenshot, the highest value (5,629,207) appears at the top with a date of 10/23/16. I need a formula that will show 10/23/16 for the max and I will do the same conversely with the Min Value and the date it occurred (in the case of my screenshot, it's 566,003 on 12/15/15). Hope this makes sense.
Like Show 0 Likes(0)

Actions
6. Re: How to get associating date for Max Value

Brian Dudley Apr 18, 2017 5:38 AM (in response to Steve Czap)

You can do it with two separate LOD expressions.

The first I called MaxOfMeasure:
{FIXED : Max([Select Rows or Time])}

The second I called MaxOccurred:
{Fixed : Max(If [Select Rows or Time] = [MaxOfMeasure] Then [Start Ts] End)}

This will get the last date in the case of ties.
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
7. Re: How to get associating date for Max Value

Steve Czap Apr 18, 2017 7:15 AM (in response to Brian Dudley)
Than you so much for the input, Brian. That worked perfectly (see screenshot). I really appreciate everyone's help. Cheers!

ETL2.jpg 148.0 KB
Like Show 0 Likes(0)

Actions