I would like to visualize conversion rates with the Trend Viz format, but the only date I have is the current month, so I have no different dates to compare. In detail, I have three different categories (A, B, and C) and I would like to display how many values each category has in the current month and the conversion rate between A/B and B/C.
An example would be:
Is this possible to achieve this
Preformatted text or should I find another way to display it?
You're looking for this:
https://github.com/metabase/metabase/issues/10021 - upvote by clicking on the first post
You can return a single string with newlines, which you can display as a Number visualization. But you would have to do it in SQL to insert a newline in a string.
Thank you very much for the reply!
I have a question about it. If I do it like this as a string, wouldn't I be losing the immediate update as if it were a numeric value?
@jg84355 I don't know what you mean by "losing the immediate update".
You would need to do something like this - this is a workaround, it won't do exactly what you want.
select concat('some', '