Hello there,
I'm new to Metabase but have quite a bit of dashboarding experience in other tools (mostly CRMs systems).
I'm making a simple dashboard with 3 filters.: Account Name, Period, and Account Owner Name.
The problem I'm having is the way the top 3 dashboard components react when no Account name is selected in the filter. Currently, those components return data of the first row in the table.
What I want to achieve, is that when no Account name is selected in the filter drop-down, the components return an aggregate of all the. "Net new user" would be the sum of all accounts and % of Active Users would be a % of the total as opposed to that one account.
Otherwise, from a user perspective the number is misleading.
Alternatively, is there a way to create a backlist value called "All Accounts" which would purposefully make sure all is aggregated?
Thank you,