I also tried creating a view with the following query to get the time difference. The view was created fine in helical & the query works fine in a regular MySQL interface too.
When i drag the student ID & the Time Difference columns, i get the below error.
Error: MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Time.TIMEDIFF(OUT_TIME,IN_TIME) as `Average Visit Time_TIMEDIFF(OUT_TIME,IN_TIME’ at line 2
Anything that can be done to get the correct output?