How can I create report based only City

[Kinetic_analytics]

Hello:

I want to have separate files based on each City only. Only that City data will be on the Excel file. How can I achieve that?

Thanks

[binuacs]

@Kinetic_analytics One way of doing this

[Felipe_Ribeir0]

Hi @Kinetic_analytics 

To have 1 excel file for each city, you can build a formula like this one creating your output name based on the city:

And feed it into the output tool:

[Kinetic_analytics]

@Felipe_Ribeir0  @binuacs in both the cases I am getting this following error.

Any idea How may I solve it?

[Felipe_Ribeir0 · Accepted solution]

@Kinetic_analytics 

Save the workflow at a folder and try again.

[Kinetic_analytics]

@Felipe_Ribeir0  @binuacs  you guys are awesome! Thank you :)