Help with Macro to select which column to use in a filter tool

I have a data-set with a bunch of columns. I'm trying to make a macro that I can select which field I want to use as the filter field. There are no errors, it just doesn't work.

In the attached macro, the default is [Outlier Above 1.0 StDev] = "Y". What I want to be able to do is select which field from the input can be used instead of [Outlier Above 1.0 StDev]. I've read tons of posts and spent well over an hour trying various configurations, but just can't get it.

Thanks for any help,

Craig

Outlier Filters.yxmc

Macros

Interface Tools

Accepted answers

IraWatt

Hey @csh8428,

Few things here. First thing there is no "Outlier Above 1.0 StDev" to replace there is a [Outlier Above 1.0 StDev] so you will need to change that.

Also this setting here will generate a list like "value selected 1","Value selected 2". If you replace the formula like this it will generate this "value selected 1" = "Y" which will always be false:

If you only want to ever select one column I would change it to this:

And this:

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Outlier Filters.yxmc

DataNath

Have amended the macro - a List Box here isn't useful as that tends to be for selecting multiple of a possible value or list of values to pass through a filter, rather than selecting an individual field, and so I've changed it to a Dropdown like so:

Edit: There was also a couple of things 'under the hood' to re-configure, but @IraWatt has covered them perfectly above!

Outlier Filters - amended.yxmc

All comments

IraWatt

Hey @csh8428,

Few things here. First thing there is no "Outlier Above 1.0 StDev" to replace there is a [Outlier Above 1.0 StDev] so you will need to change that.

Also this setting here will generate a list like "value selected 1","Value selected 2". If you replace the formula like this it will generate this "value selected 1" = "Y" which will always be false:

If you only want to ever select one column I would change it to this:

And this:

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Outlier Filters.yxmc

DataNath

Edit: There was also a couple of things 'under the hood' to re-configure, but @IraWatt has covered them perfectly above!

Outlier Filters - amended.yxmc

csh8428

Thanks @IraWatt and @DataNath !

I can only accept one solution so I picked @DataNath 's since he made it easier

DataNath

No problem @csh8428! But you can mark more than one answer as a a solution - would give Ira’s a tick as well for the explanation and detailed breakdown!

csh8428

@DataNath ahh. didn't know you could do that. Thanks! I've also accepted @IraWatt 's post as a solution.

IraWatt

😄 thanks @DataNath & @csh8428 !

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703