Help required to calculate the refresh time - Qlik Community

qlikviewforum · ‎2014-07-14

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?

datanibbler · ‎2014-07-14

Hi qlikviewforum,

I would think that should be quite difficult to answer because it depends on too many factors: The time an app takes to reload depends on the CPU_time and the RAM available at the time.

the closest you can get without getting too deeply into the details is probably taking the average time it took from the last 5 or 10 days - that is based on your exact server configuration anyway, so you don't have to worry about that.

HTH

Best regards,

DataNibbler

sujeetsingh · ‎2014-07-14

It seems you have to go for some macros...a complex thing to achieve.

qlikviewforum · ‎2014-07-14

I agree with you but I don't know the exact time taken by the dashboard today. I just wanted to know the appoximate time taken by the dashboard based on the time taken the same dashboard previously. If a particular dashboard has taken 1 hour to refresh then I would like to know what will be the appoximate time will be taken by the dashboard to refresh today based on its previous time taken?

datanibbler · ‎2014-07-14

Hi,

well, do you know it took an hour to refresh last time?

=> If that's the only reference_info you have, I'd suggest it will probably take just as long today, though it does

seem a bit long

=> The more prior reloads you have to refer to, the more accurately you will be able to predict how long it will take.

sudeepkm · ‎2014-07-14

I think as advised it is better to get an average time taken to run the task per dashboard and then you can show the time difference in your dashboard.

for example task A has started at 10 AM and avg time is 1 hour. so based on current time you can determine how much time estimated left.

qlikviewforum · ‎2014-07-14

I have the history of the reload time(Start time and End time). So please suggest based that on that how could I calculate the expected arrival time of the dashboard? Could you please with sample application/code?

sudeepkm · ‎2014-07-14

you need to load those task start time and task end time to your dashboard and then find the avg of the duration per task.

so I assume that for today's task run time you will only have the start time and no end time as the task is still running. while calculating the avg you need to ignore the current run.

in your chart/table take the task name as dimension and

then one expression as max(start time) which will give most recent task start time.

and another expression est end time which should be avg time dur + max(start time)

then one more expression as estimated time left which should be est end time - now().

Format the time according to your requirement.

qlikviewforum · ‎2014-07-14

How to calculate the average time duration? Could you please help me on this?

qlikviewforum · ‎2014-07-14

Hi All,

We have the track of Start and End time of the dashboard refresh. Based on that we would like to know by what time the dashboard will be refreshed approximately. Can someone help me out on this.

Based on the below we could get the time taken by the dashboard to refresh.

Interval(StartTime-Endtime,'hh:mm:ss')

So based on the above how we calculate approximate end time of the dashboard refresh for today? Please help..

Let me know if you have any questions?