Need some help with filtering data

[Claudiu159]

Hello, I have to find out the average quantity of items ordered in each city on a monthly basis. 

Output should look like this 

While my input is something like this 

Best way to approach this?

[dhoover]

Hi Claudiu159! I would recommend using the Summarize tool located in the Transform section of the Tool Palette.

With this, you are able to average the data from your Quantity Ordered column and group by order date > month.

[Luke_C]

Hi @Claudiu159 

You got some good suggestions in your other thread, have you tried those?  I'd suggest sharing the data itself (assuming its not confidential) instead of screenshots. 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Need-some-help-with-filtering/td-p/100...

[JamesCharnley]

You should just be able to crosstab, grouping by month, having city as Name and Quantity as value, since you can aggregate within the crosstab itself.

[Emmanuel_G · Accepted solution]

@Claudiu159 

The answer to this question is the same as that given earlier. 😉

Link to answer : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Need-some-help-with-filtering/m-p/1004...

[Emmanuel_G · Accepted solution]

@Claudiu159 

Find the version about the length of name of customers

Let me know if it works as you want or not. 🙂

I used dummy data but it's the same way with yours.

[Emmanuel_G · Accepted solution]

@Claudiu159 

Find attached the way to group by string contains in sentences.

Let me know if there is any issue with this answer.