13 Replies Latest reply on Aug 5, 2016 6:52 AM by dario.occhipinti

    How to show the corresponded date of a certain value.

    dario.occhipinti

      Hi all,

       

      I am struggling to find a way, using calculated field, to show the corresponded date of a certain value.

       

      Let's say  I have this list data source: 

      DateVolumePricecategory
      01/08/20161010.06A
      02/08/201610011.6A
      03/08/20161150B
      04/08/20165003B
      05/08/20161509.28B
      06/08/20164710110.1B
      07/08/20161114101A
      08/08/20161254884A
      09/08/2016100289B
      10/08/2016105A
      11/08/20162581600B
      12/08/20167508.86B
      13/08/201611114.24A
      14/08/201612124.2A

       

      I have prepared a table to show the average, min and max price and volume per category.

       

      What I need is to show is the date, either as second row or in the tooltip (I do not really mind) of the value. I.e. Min Price date: 04/08/2016, Max price date: 11/08/2016 and so on. In the tooltip will be more "attractive" but I just want to find a way to do so.

      Of course if I just add "Date" to the tooltip I get the asterisk  since each value has a different date.

       

      I have tried to applied  the same idea available here: Asterisks Display in Tooltips | Tableau Software  but I didn't achieve much...

       

      I open to any idea/ comments on this.

       

      Let me know if more random data are needed.

       

      Thank you in advance for your help

       

      Dario