2 Replies Latest reply on Apr 10, 2016 11:47 PM by Anuj Saxena

    How to find last year and last 6 months data in Tableau

    Anuj Saxena

      Hi Team,

       

      I am very new to tableau.I have order date column in my table.I have a requirement where I have to show a filter in report having drop down filter containing fields like last 6 months,Last Year with respect to order date.

      I have searched few discussion and got that we can write calculation field like (DATEDIFF('Month',[Order Date],[Today]).By this I can  achieve the month difference.But my question is how can I use this calculation in filter so that it comes in drop down field.Drop down filter should be like --

      Any help would be appreciated.

       

      Thanks

      Anuj Saxena