Message Box

[Anonymous]

Hi

I have a requirement to display alert message, sometimes the data build fails which result in dashboard displaying old data , so I want a message box to display stating that the data is not latest.

The data updates every Friday , so I will have to check if the data is latest Friday, so I have created a text box with the condition in Layout tab as below :

if(Date(Floor(WeekEnd(Today()) - 9)) = max(date(Date)),0,1)

But I have a filter to select the Date values in the Dashboard which by default is set to show latest Friday date , when the user manually selects a date other than the latest date , the message box is appearing , which i want to avoid . How can i achieve this?

Thanks

[johnw]

How about this as the conditional show expression?

floor(weekend(today())-9) <> max({1} Date)

[Anonymous]

Hi

This actually failed today , as today being a Friday (Data updated every Friday, so max dates will be Friday's dates only).. the msg box appeared even though the data was updated

floor(weekend(today())-9) gives me 7/15/2016 , and max date is 7/22/2016 , I should be checking current Friday's date and if current Friday's date is not equal to Max date then the msg box should appear , can you please let me know how I can check for current Friday's date as well?

May be like below , but the below is not working

(date(floor(weekend(today())-9)) <> max({1} Date) or
date(floor(weekend(today())-2)) <> max({1} Date))

Thanks

[johnw]

What do you mean by "the current Friday?" What date do you want returned for each of these dates?

Mon July 11, 2016 --> ?
Tue July 12, 2016 --> ?
Wed July 13, 2016 --> ?
Thu July 14, 2016 --> ?
Fri July 15, 2016 --> ?
Sat July 16, 2016 --> ?
Sun July 17, 2016 --> ?

[johnw]

The expression...

(date(floor(weekend(today())-9)) <> max({1} Date) or
date(floor(weekend(today())-2)) <> max({1} Date))

...is always true. It's of this form:

A-9<>X or A-2<>X

If A-9=X, then A-2 cannot = X.

If A-2=X, then A-9 cannot = X.

So the expression is always true.

It might be more obvious if you write the negation of the expression:

not(A-9<>X or A-2<>X)

which is equivalent to this

A-9=X and A-2=X

It should be obvious that this cannot ever be true. Therefore its opposite is always true.

[Anonymous]

This particular tab reloads data every Friday , so the Max Date is always a Friday's date , so I need check if the current Friday's Date is equal to Max Date , so today the application reloaded and the Max Date is 7/22/2016 , and current Friday date is 7/22/2016 , and on Monday the I still have to check with previous Friday Date which is 7/22/2016 , because the Data updates next only on 7/29/2016 .. until then date that I have to check is 7/22/2016 only.

The application reloads every day 3 times , but the data for this particular tab reloads only weekly.

so below is what I want

Mon July 11, 2016 --> 7/8/2016
Tue July 12, 2016 --> 7/8/2016
Wed July 13, 2016 --> 7/8/2016
Thu July 14, 2016 --> 7/8/2016
Fri July 15, 2016 --> 7/15/2016
Sat July 16, 2016 --> 7/15/2016
Sun July 17, 2016 --> 7/15/2016

Hope it makes sense!

[johnw]

It does make sense, thank you. This should get you those dates:

weekstart(today(),0,4)