We have a requirement to create a Survey Overview dashboard
I want to include following reports:
- Survey Scores
- Survey Scores by Category (where the category is task.service)
- Regional Survey Submissions
- Top Survey Providers
- Survey Score Trends
- Survey Submission Percentage
I also want to include interactive filters for:
- Survey Date
- Region
- Country
- Category
- Type
- Assignment Group
Can anyone guide me on how to achieve this? Specifically, which tables should I query to generate these reports? Currently, I have set up a database view on the Assessment Instances and Metric Results tables.
