How to create an overall CES survey score report from survey responses?

[SNOW_22]

Hi Team,

 I need to create a report that shows the overall CES survey score based on survey responses.

I can see the detailed survey answers under asmt_metric_result (each question with actual_value and normalized_value).
However, I am not sure which field or table should be used to calculate the final CES score for reporting.

Could you please guide me on:

1. Which table/field should I use to calculate the overall CES score?

2. Should the score be based on the actual_value, normalized_value, or another field?

3. What is the recommended way to build a report or dashboard that shows the overall CES score trend over time?

Any best practices or examples would be very helpful.

Thank you!