title: How to show running totals of time defined by an interval and time per instance
body: <p>I have a table defining an interval for when a service to a client will be performed. Also defined is the alotted duration of the service everytime it is performed. </p>
  
  <p>Like this:</p>
  
  <p><a href="https://i.stack.imgur.com/yJBdX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yJBdX.png" alt="enter image description here"></a></p>
  
  <p>The above table is an example of services that will be executed for some clients.</p>
  
  <p>For <strong>ClientId:1</strong> the information should be read as:</p>
  
  <blockquote>
    <p>Client 1 has ordered ServiceType:100 to be performed for 1.5hrs every
    third day, starting 2020-01-01 and until further notice.</p>
  </blockquote>
  
  <p>For <strong>Client:4</strong> the information should be read as:</p>
  
  <blockquote>
    <p>Client 4 has ordered ServiceType:200 to be performed for 4 hours every
    4th day, starting 2020-01-02 and until further notice.</p>
  </blockquote>
  
  <p>My boss now wants me to produce a diagram showing the total hours spent, for any service, by date.</p>
  
  <p>A date range between 2020-01-01 and 2020-01-31 should create the following theoretical dataset to display:</p>
  
  <p>(I only need to display Date and Total time, the other columns can be ignored)</p>
  
  <p><a href="https://i.stack.imgur.com/ujBgP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ujBgP.png" alt="enter image description here"></a></p>
  
  <p>The data above is then to be shown in a diagram, like this:</p>
  
  <p><a href="https://i.stack.imgur.com/RzyzW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RzyzW.png" alt="enter image description here"></a></p>
  
  <p>My issue is how to create a <strong>measure that can compute total time, given the currently selected date filter</strong> in the report and that can be used to create the above diagram.</p>
  
  <p>Any help is much appreciated!</p>
  
  <p>Kind regards,
  Peter</p>