Skip to main content
Question

How to use FME to find mean & standard deviation?

  • October 20, 2019
  • 5 replies
  • 150 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
  • 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
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+21
  • 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+21
  • 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

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

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!