Skip to main content
Question

Hello, I've found this script in order to specify a calendar under my analysis, but I do not know where to add it in order to be applied to all my widgets analysis.


imageMy goal is to specify a detailed work window for throughtput time calculation.

 

 

Thank you in advance,

 

Giulia

 

4 replies

abhishek.chatu14
Level 12
Forum|alt.badge.img+8

Not sure what you are looking for is it a filter that you want then you can take a dropdown and use the same. If you are looking to change all your charts and table apply it in the Dimension or KPI for the chart depending on the requirement


Hello Abhishek, yes my scope is to apply a weekday calendar to all my analysis. I've tried to add the script to the sheet options but it returns me back an error message:

imageimageCan you please help me understand what is missing?

 

Thank you in advance,

 

Giulia


bunyod.sap
Level 7
Forum|alt.badge.img

Hello Abhishek, yes my scope is to apply a weekday calendar to all my analysis. I've tried to add the script to the sheet options but it returns me back an error message:

imageimageCan you please help me understand what is missing?

 

Thank you in advance,

 

Giulia

The Load script accepts FILTER. I think it it better to create a KPI for your weekdays and then save it to your Saved Formulas. After that apply Filter with this KPI.


The Load script accepts FILTER. I think it it better to create a KPI for your weekdays and then save it to your Saved Formulas. After that apply Filter with this KPI.

Agreed, a bit more painful but used on my charts for analysis.