converting secs to hh:mm:ss format Data cube measures

Please help me how to convert the measure column in data cube to display hh:mm:ss when the data was in secs?

Find more posts tagged with

Comments

Added in Expersion and it works fine. Want to know is there any other way or can I add this as a function and reuse it?

BirtMath.roundDown(data["tot_time/report_date"]/3600,0)+":"+
BirtMath.roundDown(((data["tot_time/report_date"]%3600)/60),0)+":"+
data["tot_time/report_date"]%60

kallem

You can create a method out of that code. Put that method in a separate scripts .js file which you can then include in the report using Property Editor - Report -> Resources -> Javascript Files. This way you can use that code easily in other reports as well.

rajag

<blockquote class='ipsBlockquote' data-author="'kallem'" data-cid="74891" data-time="1300775818" data-date="21 March 2011 - 11:36 PM"><p>
You can create a method out of that code. Put that method in a separate scripts .js file which you can then include in the report using Property Editor - Report -> Resources -> Javascript Files. This way you can use that code easily in other reports as well.<br /></p></blockquote>
<br />
Thanks that works great.