• We have an analysis that pulls encounter data for an ER physician group. We need to exclude physicians employed under other groups. The process for excluding them needs to be very easy and user-friendly since it will need to be reviewed and adjusted weekly There are a lot of physicians in the group and always new physicians coming and going.• My idea was to create a binned column. One bin would be “Include” and one would be “Exclude”. That way, the GUI could be used to sort out these physicians—using absolutely no code.
• After the binned column step, I wanted to insert a “Filter Rows” data transformation in the data canvas. To filter out the “Exclude” binned group.
Unfortunately, I can’t seem to insert a binned column and then add a “Filter Rows” transformation as a subsequent step. There is no (+) indicator to add a step after this:
We also don’t want to exclude by using an expression in visualization properties, since these providers will still show up in the filter panel.