Hi there,
I got crime data along with the date field. Now I want to calculate the Monthly average of crime data. For instance, Crime data for Janaury 2018, January 2019, and so on. Could anyone guide me how to do in FME?
+18- Contributor
Convert the date to a month attribute using the DateTimeConverter transformer.
Then use the Statisticscalculator transformer to do the math (group by the month attribute).
Hope this helps.
erik_jan wrote:
Convert the date to a month attribute using the DateTimeConverter transformer.
Then use the Statisticscalculator transformer to do the math (group by the month attribute).
Hope this helps.
If I want to calculate the monthly average over the last 5 years, would the same method be used to get the result?
+18- Contributor
muhammad_yasir wrote:
If I want to calculate the monthly average over the last 5 years, would the same method be used to get the result?
The described method will get you the monthly average for all the months that are in the data.
If the data goes back more than 5 years, you can limit that by using a Tester (testing that the date is larger than Feb 4, 2015).
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.