How to display a little more info in a card?

Hello,

How can I show two numbers in a card like: total/average

I've tried concat the results after aggregate it but don't works

image

There are some way to show a vertical table? Something like a transposed table would be nice to fit better in the card showing few info:

This:
image

To this:
image

Hi @trialsin
There's currently not such a visualization:
https://github.com/metabase/metabase/issues/4392 - upvote by clicking :+1: on the first post
And you would have to use a Custom Column after the summarize to use concat

Thank you @flamber. Voted.

Blockquote
And you would have to use a Custom Column after the summarize to use concat

I don't got it. I don't see how add a custom column after summarize:

20220406_125904

@trialsin You would have to hack a bit by creating a fake column, which you group by, so it allows you to create another custom column - does this make sense?

I got it. Thank you!

but now I've two problems:
First how can I truncate the decimals?

And I can't filter anymore in dashboard. Just the calculated column is available


@trialsin You'll have to use SQL - can't have everything currently:
https://github.com/metabase/metabase/issues/19744 - upvote by clicking :+1: on the first post

1 Like