1 Reply Latest reply on Nov 29, 2018 7:19 PM by Deepak Rai

    how to calculate Y-o-Y metrics from a given date range

    Jason Chang

      hi all,

       

      I have a data set that currently has columns:

       

      date, # of visitors, # of orders

       

      The data consists of data from 1/1/2016 through today.

       

      I want to have a filter that has a slider for date, that allows the user to select a date range (for example - 11/1/2018 through 11/29/2018).

       

      I want my data to then display the # of visitors and # of orders for these dates, and next to it, to display the # of visitors and # of orders for the same range 1 year ago.

       

      Is this possible in Tableau? My data is a bit more complicated, but I wanted to simplify it to get some ideas on how to approach it.