How to show sum of instead count(*) on ResultsetGraph of Maximo Start Center

15 pts.
Tags:
Maximo
SQL
I have to create a Result set graph in Maximo Start Center that shows  sum of actual labor hours instead of showing count(*) on Y axis. for example, if siteid 'ABC'  has three workorders '1001','1002' and '1003' in workorder table with 3,2 and 4 actual labor hours respectively then I have to create a resultset(or resultset graph) that show this site 'ABC' and its labor hours sum 3+2+4=9, instead of showing count 3 on Y axis. Please help me to resolve this issue...thanks in advance.


Software/Hardware used:
Maximo 7.
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: