1 Reply Latest reply on Jan 17, 2019 3:08 PM by Jim Dehner

    How to show max draw down in the view?

    Meng Wu

      Hi, I'm pretty new with tableau and need some help with the this issue i'm facing. I have time series of daily P&L of different strategies and want to create a table with stats including max draw down. i tried creating a calculated field

       

      However when i tried to put this in the view, it doesn't show as desired.

       

      I want the table to be like


      Any help and suggestions would be appreciated!

        • 1. Re: How to show max draw down in the view?
          Jim Dehner

          see the attach

          As I understand the issue you just want t see the last "column"

          I added a calculation   last()  to columns and converted it to discrete (just right click it and select discrete)

          then added it to the filter and set it like this

           

          and the viz returns this

           

          Jim

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          1 of 1 people found this helpful