Median refresh time taken by dashboard over last 30 days

[qlikviewforum]

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')

[qlikviewforum]

Any idea or suggestions of this please?

[senarath]

Hi,

You could Group By Date

OR

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

[qlikviewforum]

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?

[ashfaq_haseeb]

Hi,

Check the reply of anand in below post.

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

Check if that help.

Regards

ASHFAQ

[qlikviewforum]

Hi All,

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

Thanks in advance!