---
sourceDocument: Xanadu Platform Analytics
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/now-intelligence

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu Platform Analytics

ft:clusterId :

    - par

bundleId :

    - par

workflow :

    - Platform


---

# Changes to score_start/end because of different user time zones

# Changes to score_start/end because of different user time zones {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

For formula indicators, the values of the variables `score_start` and
`score_end` are calculated based on the time zone of the user who is executing the
formula. If users in different time zones execute the same formula, the values of
`score_start` and `score_end` change.  
Warning:  
The date value of the `score_start` and `score_end` variables can shift when users from different time zones view the same formula.

Formulas can include `score_start` or `score_end` variables as
parameters for indicators that the formula references. These variables represent the first and
last second of the specific collection period being calculated for the referenced indicator. The
values of the `score_start` and `score_end` variables are
calculated from the difference between the time zone of the user executing the formula and the
time zone of the database server, which is GMT. A user executes a formula whenever they view the
formula indicator in a dashboard widget or on the Analytics Hub. As a result, the date
value of the start or end of the collection period can shift when different users view the same
formula.  

## Different values of score_end for different user time zones

Consider a formula indicator with a daily frequency and the following formula:

    pa.getScore($[[Number of open incidents]], score_end);

Three different users view a dashboard widget with this formula indicator on 18 October. The database server considers `score_end` for 18 October to be 23:59:59 GMT on 18 October.

* One user is in the Europe/Berlin time zone. Their `score_end` value is "2019-10-18 21:59:59", and the score for the date 18 October is returned.
* One user is in the US/Pacific time zone. Their `score_end` value is "2019-10-19 06:59:59", and the score for the date 19 October is returned.
* One user is in the GMT time zone. Their `score_end` value matches the database server, "2019-10-18 23:59:59", and the score for the date 18 October is returned.
{#time-zones-indicator-formulas__ul_hw3_qb1_ljb}
**Related concepts**   

* [Prevent a contributing indicator in a formula from following breakdowns](https://servicenow-prod.fluidtopics.net/KftBL97ueZwJ2qomNKiwxA "You can select contributing indicators in a formula to not be broken down. When a user applies a breakdown to the formula indicator, the breakdown does not apply to these indicators.")
* [Breakdown matrices in formula indicators](https://servicenow-prod.fluidtopics.net/arwRe8KHfg_nNnkcErCXrA "Formula indicators inherit breakdown matrices from indicators in the formula.")
* [Applying time series to result or to contributing indicators](https://servicenow-prod.fluidtopics.net/dzRy4qKDo1sknlH6AoDN8Q "For a formula indicator, a time series aggregation can apply either to each indicator in the formula individually or to the formula result.")
* [Indexing multiple indicators in a formula](https://servicenow-prod.fluidtopics.net/_~6pcilQgc15kzjsIklyQw "You can write a formula to measure what the gap is to the overall target of multiple, combined indicators. Such a formula indicator is called an 'index indicator'.")  
**Related tasks**   

* [Create a formula indicator](https://servicenow-prod.fluidtopics.net/pYgFpM6BB3XdUgPM_9DgPQ "Create a formula indicator to produce a new computed score from one or more other indicators. Besides indicator scores, the formula can include calculations such as the gap between an indicator score and the indicator target.")
* [Get analytics methods in formulas](https://servicenow-prod.fluidtopics.net/cnVqjX~HC_wNUdbpJEVaJQ "To insert a calculated value from the Analytics Hub into a formula, use a method in the formula.")
* [Detect indicators with no scores in a formula](https://servicenow-prod.fluidtopics.net/fTqPC09KyYCVj_CvqcZxDg "As the formula creator, you can handle contributing indicators that have null scores. First set the formula indicator to calculate the formula even when it contains a null score.")  
**Related reference**   

* [Performance Analytics variables](https://servicenow-prod.fluidtopics.net/CYiEQxaEFqweMc4TScuxXg#r_ScriptsForAutomatedBreakdowns "Several variables are available for use in Performance Analytics scripts and formula indicators.")