Skip to main content
Question

How to use FME to find mean & standard deviation?

  • Oct 20, 2019 7:39 AM UTC
  • 5 replies
  • 224 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?

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.

5 replies

Forum|alt.badge.img
  • Oct 21, 2019 2:15 AM UTC
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
  • Oct 21, 2019 4:37 AM UTC
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+24

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+22
  • Safer
  • Oct 25, 2019 6:26 PM UTC

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
  • Oct 25, 2019 8:01 PM UTC

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!