Skip to main content
Question

How to use FME to find mean & standard deviation?

  • October 20, 2019
  • 5 replies
  • 112 views

dataninja
Forum|alt.badge.img

Alteryx has a tool called smart tile and I am having trouble replicating it in FME.

https://help.alteryx.com/2018.2/Tile.htm

Can anyone give me some advice on how to replicate the tool in FME?

5 replies

Forum|alt.badge.img
  • October 21, 2019
Hi, you may try to use "Tiler" transformer in FME, but you would also need to make the feature containing specific values beforehand.

dataninja
Forum|alt.badge.img
  • Author
  • October 21, 2019
mileslee wrote:
Hi, you may try to use "Tiler" transformer in FME, but you would also need to make the feature containing specific values beforehand.

Do you know how I can replicate the smart tile feature?


debbiatsafe
Safer
Forum|alt.badge.img+20
  • Safer
  • October 25, 2019

Not personally familiar with this tool. But based on the Alteryx documentation, I would recommend trying to use the StatisticsCalculator to find the mean and standard deviation. To find the tile number, try an AttributeCreator with conditional values set up based on whether the value is within 1 standard deviation of the mean. This is a similar Q&A post.

Example workspace: assignvaluebasedonstandarddeviation.fmw


fmelizard
Safer
Forum|alt.badge.img+18
  • Safer
  • October 25, 2019
debbiatsafe wrote:

Not personally familiar with this tool. But based on the Alteryx documentation, I would recommend trying to use the StatisticsCalculator to find the mean and standard deviation. To find the tile number, try an AttributeCreator with conditional values set up based on whether the value is within 1 standard deviation of the mean. This is a similar Q&A post.

Example workspace: assignvaluebasedonstandarddeviation.fmw

Just because it looked fun, I added to Debbie's solution by using a ValueMapper to assign even more categories ("tiles") after doing a bit of calculation in an ExpressionEvaluator. As always, many paths to success here .. smarttiler.fmw


dataninja
Forum|alt.badge.img
  • Author
  • October 25, 2019
fmelizard wrote:

Just because it looked fun, I added to Debbie's solution by using a ValueMapper to assign even more categories ("tiles") after doing a bit of calculation in an ExpressionEvaluator. As always, many paths to success here .. smarttiler.fmw

This is great! Thanks so much for your help!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings