Help required to calculate the refresh time

[qlikviewforum]

We have dashboard which tells at what time refresh has started and by what time the refresh has ended. We would like to know by what the time the same dashboard which has started is expected to complete the refresh? We would like to calculate the ETA(Expected time of arrival(Approximately)).

Imagine if the dashboard refresh is started today at 07/14/2014 10:15:00 AM and based on the yesterday's interval it took 1 hour. So based on this detail we could approximately say that the dashboard refresh will complete appoxiamately at  07/14/2014 11:15:00 AM.

Can some one help me on this please?

[qlikviewforum]

Any updates or suggestions from anyone?

[richard_pearce6]

Hi,

Challange is to do this automatically and calculate an average you need to store the refresh times somewhere.

It's possible to use variables as they remain constant each refresh so you could set up say 10 variables and at the end of each load move the values down one..... something like

Let vAve10 = vAve9;

Let vAve9 = vAve8;

Let vAve8 = vAve7;

Let vAve7 = vAve6;

Let vAve6 = vAve5;

Let vAve5 = vAve4;

Let vAve4 = vAve3;

Let vAve3= vAve2;

Let vAve2 = vAve1;

Let vAve1 = This Reload End Time - This Reload Start Time;

Then average the 10 variables and display the results in your dashboard, planned start time + ave completion time as an ETA.....

or....

You can store the informaiton into a QVD file using methods described here http://community.qlik.com/docs/DOC-6187

And then load the QVD as normal performing the calculation.

Richard