7 Replies Latest reply on Sep 3, 2018 10:56 PM by Shinichiro Murakami

    Splitting Up an Event Duration to Different Months

    m_fol

      Dear Community,

       

      I have the following data showing the duration (days) of events:

      Data.png

      This data can e.g. show the days a bus is out of service due to maintenance.

      I want show the out of service days per month. What I can do with tableau quite easily is showing the duration based on the start date:

      Tableau Screen.png

      This chart is misleading, as a bus was out of service in march. So how can I create a visualisation, that splits that duration and assignes it to the respective months. So ID 1 will count with 3 days for February and 13 days for March, resulting in a view like this:

      Excel Screen.png

       

       

      I appreciate your support.

       

      Packaged workbook attached with dummy data, version 10.4.1