How to calculate the apporx time that will be taken by the dashboard based on yesterday's date?

[qlikviewforum]

We have the details of dashboard’s start time and end time in the database. Based in the Interval function we are calculating the time taken by the dashboard to refresh. In of the chart we are showing the start time of the dashboard, based on the time taken by the dashboard to refresh on the previous day we would like to show the ETA(Expected Time of Arrival) of the dashboard.

For example,
If the Dashboard refresh has started today at 04/08/2014 11:10AM, if the total time taken by the same dashboard on the previous days is 1hour and 10minutes. Then the we would like to show the ETA as 04/08/2014 012:20PM.

Can someone help me on this please?

[#2]

Hi,

For that you can store your time in one variable like addtime(Minutes) and follow below code

YourFieldName= your time (04/08/2014 11:10AM)

addtime=70(1hour and 10minutes) convert your time to Minutes format

Timestamp(YourFieldName+Time#(addtime,'mm')) as NewTime

now NewTime has your expected value 04/08/2014 012:20PM