How to handle Timestamp field in Chartw

[#1]

I have a timestamp field in my dataset .

What is the best possible way to handle this timestamp field in data model and also using this  in the  straight table as dimension  without compromising on performance

[sunny_talwar]

For the back end scripting part, check this link out: The Master Time Table