Are formula scores persisted within the scores table?

Formula scores in the context of analytics are calculated dynamically based on the data they are derived from at the time of the request or analysis. They are not stored in the scores table because the scores are intended to reflect the most current state of the underlying data. When a formula score is calculated, it derives its value from real-time or updated data rather than being a fixed value that gets saved for future queries.

This approach helps ensure that all analytics reflect the latest data changes without the need to frequently update stored score values. Such real-time calculation of scores aligns with the demand for accuracy and timeliness in data reporting and decision-making, making it efficient for users who rely on analytics for insights.

When evaluating the nature of formula scores, understanding that they are not persisted helps clarify their role in analytics, which centers around immediate calculation rather than historical storage.