Thank you Abhishekg.
For MySQL database, you can calculate the difference between the first and latest data in Helical Insight. For that, you would require custom column.
Follow the steps to implement :
1) Go to Adhoc Mode
2) Double click on selection panel region to open Custom Column Window.
3) Insert the code:
TIMESTAMPDIFF(HOUR, col1, curdate())
whereas : col1: first data
4) Provide custom column name.
5) Click OK to confirm.
6) Now, click "Generate report" to view output.
Similarly, depending on the database other database functions are used for calculating timestamp difference.
Helical Insight Team