Why does Domo not have a simple way to delete certain rows that match a criteria?
How can I delete certain rows from a dataset? Analogous to SQL "DELETE FROM"
Because of how the underlying architecture of Domo and data storage in general it's not like a Database where you can just simply run a DELETE FROM type command.
What you can do is do a dataflow to input your dataset, filter out the rows you don't want and then write it out to another dataset.
I would add that after writing it to another dataset, you can request for those rows to be deleted via Domo Support.