Hi I have a Inspection (Audit) app consisting...

(Pieter Botha) #1

Hi I have a Inspection (Audit) app consisting of 120 questions. Questions are grouped together in categories. Each category’s questions are in a different Table structure. I now what to generate a view that will give a user a overview of a number of issues, Number of audit failures, scores etc. This however needs to be in a single view based on all the Tables. Is there any way of doing this? I was adviced to create an additional Table and then to use Virtual columns to create summaries. Can’t see how this will work to get data in the right order (store name, date, category, score)

#2

Hi @Pieter_Botha Have you tried making a slice from your new table and rearranging the columns?