Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Median refresh time taken by dashboard over last 30 days

Currently we are using the below formula to calculation the median time taken by the dashboards. This gives median time based on the overall data which we have(Day 1 to till date). But the user wants to know what is the average time taken the dashboard over last 30days. Could you please help on this?

interval(median(DB_REFRESH_END_TIME - DB_REFRESH_START_TIME), 'hh:mm')

5 Replies
Creator II
Creator II

Any idea or suggestions of this please?

Creator III
Creator III

Hi,

You could Group By Date

OR

Aren't you get the information from LOG files or use below application.

Creator II
Creator II

Hi,

Thanks for you response.

We don't want to get the information from the log files We would to do whatever the information we have in our database. Could you do some changes in the above to achieve the result?

Hi,

Check the reply of anand in below post.

http://community.qlik.com/thread/128164

Check if that help.

Regards

ASHFAQ

Creator II
Creator II

Hi All,

Which will be the easiet way to calculate the Last 30 days Median? Please help!

Thanks in advance!