3 Replies Latest reply on Dec 6, 2018 5:16 AM by Amit Narkar

    Calculate Number of Events between other Events depending on the Type of the Event

    m_fol

      Dear Tableau Community,

       

      following issue:

      I have different cars that have inspections on certain days. Multiple inspection types are possible, the focus though is on L=large and S=small. I need to calculate the number of S inspections between the current and the last L inspection for each car. I have added the desired result to some data for a better understanding:

      Desired Result.png

      Those red numbers will be used to calculate the average number for each month. This is the desired output that needs to be shown in a dashboard:

      Monthly.png

      I tried various calculated fields without getting close the desired result, so I will be happy if someone can help me here.

       

      Best Regards

      Marco