4 Replies Latest reply on May 2, 2016 2:23 AM by Tableau kumar

    Splitting metrics by time chunks when only start/end date are in data source

    Xavier Adam

      Hi all,


      I am trying to do something that might not be possible using only Tableau.


      I have a dataset containing 5 columns:


      - Rental Order ID

      - Rental Product Name

      - Rental Order Start Date

      - Rental Order End Date

      - Rental Order Revenue



      Orders usually span over 50-90 days (so 1.5 to 3 months). I would like to display the revenue generated by months, knowing that the 'daily revenue of an order' (or 'rate') is


      [ Revenue Rental Order ] / DATEDIFF('day', [ Rental Order Start Date ], [ Rental Order End Date ])


      Changing the data source is not an option . I attached a sample.


      Ideally I would like to end up with something like, with, if possible, dynamic dates that can be grouped by days/months/quarter/year.


      Thanks a lot for any ideas.