Filter with unique

Oliver

Unfortunately the Google Sheets Query function doesn’t have the possibility to use the DISTINCT clause, and then you have to wrap your formula inside an =unique() formula.

However, our conditional filter has become so powerful that perhaps we can apply this feature inside of it like a radio button you toggle on or off.

Karoline from Sheetgo

Hi @Willian from Sheetgo What’s your take on Oliver’s idea? 💡
I’d love to hear your insights on this one.

Willian from Sheetgo

Karoline from Sheetgo Thanks for pinging.

Oliver’s idea seems reasonable, however, the proposed solution doesn’t appear scalable to me. I’m wondering how we could architect something more towards empowering our filter by condition feature, where you could use functions from the native SQL or based on BigQuery SQL, so when you select the columns, you could choose transformers and aggregators based on their data types.