We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Tile Tool - No values found before GetMean()

Daedalus
6 - Meteoroid

Good day,

 

I was actually trying to use the tile tool and we encountered this type of error. Please help on what to do:

 

Quartile Test

 

We were trying to determine the true price of one product and thought of using the tile tool. 

I tried removing the Grouping Fields "Product" and it did work. But the thing is that we needed them grouped so that it wouldn't use all of the prices across all products and so that it will only calculate for a certain product to get their true price. 

 

Please advise.

 

Thanks

2 REPLIES 2
simon
11 - Bolide

I ran into this problem before. Check your data for null values and replace with 0.

Daedalus
6 - Meteoroid

HI Simon

 

Thanks for giving me the idea about the null values and zeros. What I actually did is removed the zeros from my data. For some reason, the tile tool doesn't accept zero numeric values. I filtered them out from the data and everything worked. Maybe because the zeros will have an effect in the averaging of numbers while using the Smart Tile setting.

 

Thanks again!

Labels