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

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:

To this:

Hi @trialsin
There's currently not such a visualization:
https://github.com/metabase/metabase/issues/4392 - upvote by clicking
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:

@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
on the first post
1 Like