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