FAQ under here
Edit data source ==> Pivot data
If you have value more than 24 hours, Answer becomes more complicated and i ant you to wait this will be answered in 4 days if you can wait..
time_pivot_SM_10.1.twbx 156.1 KB
Thank you very much for your quick response and solution. This is great!!
I'm able to create a chart as you suggested. Next level, I have to do the same by connecting with Teradata database to pull and report in line chart. I'm working on that. Will let you know if I need any further assistance.