Smart Tile Grouping Values

I'm using the Smart Tile to review 90 days worth of information. The results provide groupings up to 3 STD in each direction around an average as I expect. Is it possible to retrieve the values of each grouping?

For example, when I receive a record returned from Smart Tile that contains "Extremely High (Above 5600)", how might I retrieve 5600 from Smart Tile? Also, how might I received 5600 from Smart Tile even when there is no record that contains it?

Thanks!

Joe

Developer

Data Investigation

Accepted answers

apathetichell

How about:

run the figures you are looking at through a summarize tool to get the average and the standard deviation.

If they are normalized to log 10 - keep that in mind. the numbers I'm running are so the examples below will be.

pow(10,[Avg_LOG10(Sale)]-(2.5*[StdDev_LOG10(Sale)])) should match your extremely low

and

pow(10,[Avg_LOG10(Sale)]+(2.5*[StdDev_LOG10(Sale)])) should match your extremely high threshold.

If your numbers aren't log10-ed then obviously don't bother with the pow() function. To test your data try running the same formulas with 1 and 1.5 stdev to see if it matches the Alteryx results.

All comments

CharlieS

Are you referring to the Smart Tile setting within the Report Map tool? If so, there is a way to extract that information from the legend.

- In the Report Map tool, set the legend position to "Separate Field".

- Use the Map Legend Splitter tool on that separate legend field and it will parse out the information you seek.

https://help.alteryx.com/current/designer/map-legend-splitter-tool

jdemeyer

Thanks CharlieS!

I tried your suggestion. The data source does not contain spatial information so the Report Map had nothing on which to operate (if I understand the error message correctly). Cool idea tho'!

My data is a count by date (e.g., 1/1,45, 1/2,78,...) and Smart Tile provides an analysis that groups the data into Standard Deviation bins. Smart Tile provides some information about the bin as I noted ("Extremely High (Above 5600)"). I would like to get that 5600 from Smart Tile.

Thanks!

Joe

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703