@deepanshu_chamo I can imagine a couple of different way to accomplish this, but it most suitable option depends on your data table with the working hours. Please share a sample QVF of the working hours table that you are aggregating from.
@deepanshu_chamo I partly misinterpreted the question before, so thank you for the clarifying sample.
I have been thinking about this scenario, and my main suggestion would be to transform the interval for each incident to one record per date, then calculated the shift time per record. That way your aggregation in visualization becomes a simple Sum()
@deepanshu_chamo it's not really a simple formula. I'm suggesting that you model the data in a way that you can use a simple Sum() to aggregate the hours. The principle would be to represent each incident with one record per date and have the adjusted shift hours per-incident and date.
See attach example. Note, this is not a fully functional sample, as it for example does not cover a scenario where an incident is opened and closed on the same day. You probably also want to consider some incremental QVD logic to minimize this loop to go through all records at every reload.
