Chart with percentages calculated on the fly using an expression

Hi There –

We are evaluating the Metabase with Druid.

We were wondering if the tool would let us define an expression.

For example, is there a way to chart the percentage of successful transactions, where the percentage would be calculated on the fly with an expression –

For example, with a Druid visualization tool Pivot (, we can define a “measure” as below and it would derive the % on the fly …

  • name: percentage_unique_accts_successful
    title: Percent Successful Accounts
    expression: $main.filter($flag == ‘Approved’).countDistinct($acct_unique) / $main.countDistinct($acct_unique) * 100

Thanks for any help in advance.