Skip to main content
Question

Creating report based on when jobs were still open

  • August 9, 2019
  • 1 reply
  • 9 views
S
Forum|alt.badge.img

Hi,

I have some data in the following format:

Job

 

Raised

 

Closed

 

1

 

20190715

 

20190825

 

2

 

20190611

 

20190825

 

3

 

20190614

 

20190825

 

 

I want to get a summary table, about for each month, how many jobs I had open. So for the above data it would be:

 

Month

 

Raised

 

Closed

 

Open

 

June 2019

 

2

 

0

 

2

 

July 2019

 

1

 

0

 

3

 

August 2019

 

0

 

3

 

0

 

 

I can do the raised and closed, but am struggling with the open. I tried using a testfilter, with a lot of if statements, which works, but then I not sure how to export that into a format that i can use the data.

 

Help :)

 

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

redgeographics
Celebrity
Forum|alt.badge.img+60
  • redgeographicsCelebrity
  • Celebrity
  • 3701 replies
  • August 9, 2019

You can split both the Raised and Closed dates into year-month-day (AttributeSplitter or some SubStr expressions in the AttributeManager), if the raised/closed day, month or year values are different it should count as an open job. Then duplicate it (month closed - month raised + 1) times and then count them.

FME rocks! \m/

Community Stats

32,079
Posts
121,818
Replies
39,714
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.