how to use filtered data in beast mode?

John_LARM

So I think this is pretty simple, but I'm not able to find how. I want to make a field using data that I can only get after a filter is applied. Basically I want a percentage. Using a count(field) I can get the total number of widgets, but I want to know how many of those widgets are purple, but I can only find out the number of purple widgets after I apply the filter to widgets.

so I'm looking for something like count(widgets - purple)/count(widgets) but I don't know how to actually enter the filtered results.

Thanks in advance

ColemenWilson

Assuming your Widgets field is numeric:

SUM(CASE WHEN `WidgetColor` = 'Purple' THEN `Widgets` ELSE 0 END) / SUM(`Widgets`)

Data_Devon

In my experience, the CASE WHEN statement has been the single most useful argument I've used for BeastModes. To solve your question, I'd do something like this:

COUNT(CASE WHEN `Widgets` = 'Purple' THEN 1 ELSE 0)

— the CASE WHEN argument looks at your `Widgets` column and returns a 1 if it's purple. You then count all these 1s to get the numerator of your solution

/

— Then you divide

COUNT 'Widgets'END

— by the total count of widgets.

This should get you close - keep us posted on progress.

ColemenWilson

Assuming your Widgets field is numeric:

SUM(CASE WHEN `WidgetColor` = 'Purple' THEN `Widgets` ELSE 0 END) / SUM(`Widgets`)

Data_Devon

In my experience, the CASE WHEN statement has been the single most useful argument I've used for BeastModes. To solve your question, I'd do something like this:

COUNT(CASE WHEN `Widgets` = 'Purple' THEN 1 ELSE 0)

— the CASE WHEN argument looks at your `Widgets` column and returns a 1 if it's purple. You then count all these 1s to get the numerator of your solution

/

— Then you divide

COUNT 'Widgets'END

— by the total count of widgets.

This should get you close - keep us posted on progress.

Data_Devon

@ColemenWilson is 🐐🐐🐐 so either of these solutions should work for you John_LARM

John_LARM

Thanks