Hi, how can I put TIMESTAMP data in my crosstab measures area ?
THX ;)
I might be wrong, but I don't think that's possible. Crosstabs are all about numeric measures. No doubt someone will prove me wrong, but you mighthave to go down the route of making a list report that looks like a crosstab.
A list report that looks like a crosstab ? You mean that i have to list all of the possibles values of my column ? I should call it an almost "crazy" idea.
But if I haven't no other choices, I am bound to do it...Horrible...
I guess we can..
SR
Just out of curiosity, why do you want to have a timestamp as a measurement?
/ Rob
I can think of a few reasons you might need to see time as a measure in an xtab. Suppose you have a pivot of agents in rows, queue in columns with time logged in, time logged out, duration nested.
Corner | Queue 1 |
| Log in| Log Out | Duration |
--------+-------+---------+----------+
Agent 1 | 09:00 | 10:00 | 1:00
Agent 2 | 08:55 | 10:00 | 1:05
Agent 3 | 11:30 | 12:00 | 0:30
and so on.
It's certainly possible to get timestamp data into a pivot, since timestamps are essentially numeric in origin. Depending on the data source it's a simple matter of converting to epoch (seconds from 1970, or any other base), finding the min/max/diff. Once the xtab is built, unlock the report and click on the <1234>. Change the source type to report expression and use the report functions to cast back into timestamp format. You can then use the datatype formatting to format to your needs.