Blank records in source file

[#1]

Hi,

I have a dashboard with 3 tabs which is using excel as a source.There is one date field in the excel it should not be blank (as per the business requirements).

My requirement is if any blank records exists in the date field my dashboard should not refresh and it should show some error message saying that The date field is having blank records so dashboard board will not execute.

Any best suggestions to implement this.

Thanks,

[prieper]

Give it a try with a condition basing on COUNT-function, like

COUNT(IF(LEN(CriticalDateField) = 0, KeyField))

in order to show a text-field, show an error-message in the graph, hide the dashboard ....

HTH
Peter

[#3]

I would also think about using an alert with the condition

COUNT(IF(LEN(CriticalDateField) = 0, KeyField)) <> 0

to send an email to whoever needs to resolve the issue, using 'On Post Reload' event when in batch mode.

Regards,

Gordon

[#4]

Hi Gordon,

Could you pls let me know how to implement using this Alert function.

Thanks,