Show/Hide based on last refreshed date

[#1]

Hi, I am trying to find out how to do the following:

When a dashboard hasn't refreshed for >24hrs, I'd like a message to be displayed (automatically) on the opening tab of the dashboard, so when a user goes to the accesspoint, they will be able to see the message.  Is there a way to set up the dashboard file that has been distributed to the documents folder (i.e. hidden script) to auto reload if it hasn't been refreshed in >24 hours?

Thanks!

Mike

[quwok]

Hi Mike,

you can derive it using the following logic:

= if(Now() < Timestamp(ReloadTime() + 1), 'Less than a day ago' , 'More than a day ago')

This translates to the following condition which you can paste into the show condition of your label

= not(Now() < Timestamp(ReloadTime() + 1))

(Note the above is more focus on readability than efficiency )

[#3]

Thanks for the response.  This part I can do, but it doesn't address the reload of the dashboard if the >24hrs condition is met.

[Anonymous]

Michael

Are your dashboard qvw's scheduled to be auto reloaded ?  [I use Publisher to schedule auto reload tasks]

If so then how often ?

If you have scheduled reloads and they are failing then maybe it would be better to eliminate the root cause of the failures.

Best Regards,     Bill

[#5]

Hi Bill, thanks for the reply.  The tasks themselves are not failing.  I have everything set up on EDX triggers.  So, if an ETL job is running behind for whatever reason, once it has been 24hrs since the last refresh, i want users to be notified. 

[Anonymous]

Michael

Fair cop.

Quwok suggested earlier how the Users could be notified.

If an ETL job is running behind for whatever reason, then auto forcing a reload of the dashboard could well be unwise until the reason is identified & sorted,

Best Regards,     Bill

[#7]

Hi Michael,

Using QEM you can notify your users, just program an alert mail and add mail accounts that you want.

Best regards

[#8]

I already have an alert set up if the job fails.  This is for a job running longer than expected.