Search

directory_1.jpg
1 to 10 of 66
Sort by

Answer
RE: Calculate Duration between status dates

​Hi Rob, have you tried creating a view? Try something like this; I use this combined with another view. Just do the math for each row you could even add select(Select review - draft, draft - review from (MR Metrics) etc. to get the duration. Works great in Tableau as well. (Just identify the...


Answer
RE: Calculate Duration between status dates

HI Rob, This is something I did for a result set and a KPI, perhaps you could use parts of it to get what you need. This looks at all workorders generated for the previous month that I compare the status change and the change took between 3 and 5 days. This is in SQL Server and you would...


Answer
RE: Calculate Duration between status dates

We've used the LEAD() and LAG() functions in Oracle / SQL Server to calculate timespan information between rows. Mostly this has been used in KPIs, but the query syntax could absolutely be used in a BIRT report. Oracle: https://docs.oracle.com/cd/B19306 01/server.102/b14200/functions070.htm SQL...


Answer
RE: Calculate Duration between status dates

Thank you all for your responses. I think I figured out a way to do this in Tableau, as it doesn't seem possible to do in QBR.


Answer
RE: Calculate Duration between status dates

I think you should consider a 3rd party reporting tool, or BIRT if you can build there. QBR works well when you are looking at different fields on the same record, but you are looking at different records in the WOSTATUS table. If you look at say work order 1002 (Rebuild Feedwater Pump) in...


Answer
RE: Calculate Duration between status dates

You could potentially add a couple of date fields to the WORKORDER object and populate them via Formulas or Automation Scripts. The tricky thing becomes how to handle scenarios where you hit a particular status more than once.


Answer
RE: Calculate Duration between status dates

Hi Steven, Thanks for replying. I don't need it between every status, but I would like it between say WAPPR->APPR and SCHD->COMP. I don't think I could necessarily pick and Choose like that, though. It would be all or nothing, right?


Answer
RE: Calculate Duration between status dates

Doing it in a QBR would require it to be stored in Maximo persistently or you'd have to export the report and modify it in BIRT. Are you looking for time between specific progressions like you called out or are you looking just between the most recent status before it? For example, if a WO went:...


Question
Calculate Duration between status dates

Hello All, I am trying to calculate the duration in days/hours between status dates, for example WAPPR->APPR, APPR->SCHD, etc. in an ad hoc report. Looking for a way to do this within Maximo, as opposed to having to export to excel, etc. Thank You, -Rob