Add chart page, I can select many dimensions(say, d1, d2, d3, d4) so the sql is like
select d1, d2, d3, d4, measures from t group by d1, d2, d3, d4;
dashboard page, I wish dimensions could be temporarily disabled, e.g., I remove dimension
d2, so the sql run behind the scene could be like
select d1, d3, d4, measures from t group by d1, d3, d4;
It’s a common use case from my point of view because our customized data visualization front-end works in this way XD.