Handing timestamp in chart

[#1]

Hi I have a timestamp field in my source data with 10 million approx distinct data.

There is only one straight table where i need to display this timestamp value in my qvw.

Now we have read in community that to optimize the performance of the qvw application we should not use the timestamp instead use the date .

Could someone please suggest a way to use this timestamp field with more

Note: i am using the date of the time stamp to link with my calendar and using this timestamp value in only one straight table

[sunny_talwar]

May be this blog will be helpful: The Master Time Table

Best,

Sunny

[MarcoWedel]

‌maybe helpful:

Symbol Tables and Bit-Stuffed Pointers

regards

Marco

[rwunderlich · Accepted solution]

Break the timestamp into two separate fields -- Date and Time, using script such as this:

date(floor(mytimestamp)) as MyDate,

time(frac(mytimestamp) as MyTime

-Rob