The idea here is to expand the formula editor (Specifically CASE WHEN Statements) to allow the creation of dimensions or "buckets" based on filtered data. This is useful on the dashboard level as we ...
I wonder if the 'Dynamic Buckets' plugin doesn't do most of what you want. The definition is in the widget script, not the formula, but you should be able to get results.
Iris