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.