Data Exploration and Broswe Tools

Question

Hey All,

In my use of Alteryx, I end up showing browses a lot in meetings, going over data, and walking through filtering steps with stakeholders.

I find its a great way to get my stakeholders invested in how much Alteryx can do and helps us speak the same language.

However, the biggest feedback and pain point I have is all of my numbers are unformatted, I.E. "Is that 3 Million or 30 Million?"

Is there a quick and easy way to format my browse so we can easily determine thousands places?

I'd like to avoid creating a new field as a string and writing Reg-Ex to add commas in all Thousand, Mil, and Bil cases, but if that's the only answer I can do that.

I'm really just hoping there is a magic "Browse Setting" I'm blissfully unaware of!

Thanks!

- Will

Capture.JPG

TheOC · Accepted Answer

Hi @willcogs26 !

I have found the best way to use a formula tool with the ToString function, here is an example:

I have attached this workflow, Hope this helps!

Blake · Accepted Answer

Hi @willcogs26

You could use a table tool + a browse to do this. It will increase your processing time by a little bit but will also allow you to do things like control the number of decimal places shown and add prefixes such as dollar signs.