4 Replies Latest reply on Sep 20, 2016 1:57 AM by Tanmay Gupta

    Check Maximum value in a row and Lookup Column Header - and Display

    ALAN BARBER

      Hello experts,

       

      I am new to Tableau and wondering how to perform the following task.

       

      I have a table with Date rows and Station columns as follows:

       

                      St1         St2         St3        St4

      Date1  |   34          22          11          87

      Date2  |   19          28          28          44

      Date3  |   11          88          22          11

      Date4  |   11          10          87          34

       

      My problem is that I just want to display in the bar chart the maximum across the row and return the column, and the value.

       

      Date1    |     St4     |     87

      Date2    |     St4     |     44

      Date3    |     St2     |     88

      Date4    |     St3     |     87

       

      Its essentially equivalent to a lookup in Excel, but I need to do it in Tableau.

       

      I am attaching the view for my project (x=Date, y=StationName)

       

      Thanks for any help you can give!

       

      Captureviz.PNG