Skip to main content

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

 

 

Thank you in advance,

 

Giulia

 

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


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.


Reply