Showing survey question and responses in single column in incident survey report

[svirkar420]

Hello Developers,

I have a requirement in my project where I need to show the report for incident survey in such a way that it should look like a rating given like for Q1. The response for the Q1 for survey should be seen below the Q1 column.

In simple words here Q1 will be the table header and response submitted to that Q1 should be the table content which should be seen below the Q1 column.

I have attached the screenshot for this with this post. Please find it.

Your inputs will be valuable.

Best Regards,

Saurabh V.

[svirkar420]

@JackieZhang ,The tables that are used in customer instance is also OOTB tables, there are no custom table being used. So, that same can be implemented on the PDI as well.

[JackieZhang]

then for database view, you need to left join several tables by assessment instance id.  

[JackieZhang]

for example 

instance ins 

question_1   q1.instance_id =  ins.sys_id

question_2  q2.instance_id =  ins.sys_id

question_3  q3.instance_id =  ins.sys_id

question_4  q4.instance_id =  ins.sys_id

[JackieZhang]

Another solution is we don't use dashboard， we can create a UI page to show the data to customer

[svirkar420]

@JackieZhang , No they want a report and that report will later be added to the dashboard. But the real problem how do we make the report in this way it is in the Posted question's screenshot that is the main requirement.