-
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
-
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
-
-
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
-
-
4. Re: How to get associating date for Max Value
subodh Thapliyal Apr 17, 2017 3:19 PM (in response to Steve Czap) -
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.
-
6. Re: How to get associating date for Max Value
Brian Dudley Apr 18, 2017 5:38 AM (in response to Steve Czap)1 of 1 people found this helpfulYou 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.
-
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
-