I am trying to create a heat map report based on Metric Results [asmt_metric_result] to show completed instances in the last 90 days and I am filtering for one metric type of 'IT Incident Survey'.
I want it to look something like this (based on incident):
I created a data source using the metric results table and added the conditions:
- instance.created | on | last 90 days
- instance.metric type = 'IT Incident Survey'
- instance.state = complete
When I try to set Row as Question, I get an error "Cannot generate the report. This report contains too much data to visualize....."
I can see the 'question' field on the Assessment Metric [asmt_metric] record
so I thought I could dot walk to it that way but I don't see it listed to select:
I know the text will be truncated, but I'd still like to display the question if possible. Am I missing something? Do I need to report from a different table? I have also tried this with the Assessment Instance Question [asmt_assessment_instance_question] table and got similar results.
I'm also open to suggestions if you think there is another report type that will display the same information.
Thanks.
