One of our customers asked us to help them to put a dashboard together. They have a case where they need to control several attributes based on specific metrics. For example, let’s say we need to control product groups and categories based on four metrics (quantity, revenue, commission, transactions).
We’ ve created four charts grouped by product groups, one for each metrics. And four more grouped by product category, also one for each metric. We’ve ended up with 8 visualizations and the dashboard looks big.
Is there a way where we can modify the group by for the four initial charts? I know that we can go one by one and change the attribute. But I was talking about something like a function or so. That way we could circle between different attributes re-using the same charts.
I hope you guys understand my puzzle lol.