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.

  • May 22, 2023
  • 4 replies
  • 8 views

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

 

 

Thank you in advance,

 

Giulia

 

4 replies

abhishek.chatu14
Level 11
Forum|alt.badge.img+4

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


  • Author
  • Level 5
  • May 24, 2023

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
  • Level 7
  • May 25, 2023

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.


  • Level 8
  • May 26, 2023

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.