Trend visualization without dates

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:

% 45.54

Is this possible to achieve thisPreformatted text or should I find another way to display it?

Hi @jg84355
You're looking for this: - upvote by clicking :+1: 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', '
', 'thing')

1 Like