Data of friday showing on monday

Hi everyone,

i have created a dashboard which shows monitoring data which are raised from monday to friday.
The dashboard shows the data for the previous worday (e.g. on a tuesday it shows the data from monday).
My problem is the monday. Is there a way to script or to filter that the dashboard shows the data of friday on a monday.

Thanks.

1 Like

Hello @alexander.reiber,

Yes, you can create a script for this scenario.
This script should be activated only on Monday. First you can check the date of the system and if the date==Monday this script will run each time when the dashboard will be loaded (on ready). After this, you should have in your dashboard the latest Friday date (in a DataLabel, table etc) extracted from the DataCubes. Now you can create the script, by sending to it the ranges which filters the dashboards.
https://www.dundas.com/support/support-center/support-articles/scripting/modify-a-filter-/-view-parameter-using-scripting
You will have some variables which will be added to the filter script which contains the date of the latest Friday.
Another option could be the usage of the tokens but for this case I think you have to create a specific token.

1 Like

Hi Alexander,

It sounds to me like you might want to try to do something like this with a custom date token. Here is a video that I did on the subject.

1 Like