Can I have user enter a value that can then be displayed dynamically in single row hardcoded report?n displays in a title?

Get Help
1

Hi everybody,

Users currently use a dynamic SQL filter to select data for a specific customer.
Can we have the value entered in that filter displayed in something that will appear as a report title?

Sales Report for x
"x" being the customer they enter

2

Hi @komsinica
Currently no, only the results are part of what is being filtered.
You could create a question like select concat('Sales Report for ', {{filter}}) where you place it on a dashboard as a header.

1 Like
3

Hi Flamber. Thank you so much for the super quick response, that worked like a charm.

4

@flamber, when you say "place it on a dashboard as a header", could you please elaborate? Should I use the Number visualization and place that on the dashboard as a makeshift dynamic heading?

5

@OnlineChampion Yes, exactly.

6

Screenshot%202022-06-30%20185527
Screenshot%202022-06-30%201855273230×570 97.1 KB

Thanks for your reply.
It would be great if the Number visualization settings had the ability to adjust text size and the text wrapping. Are there any work-arounds?

7

@OnlineChampion Currently no - you're seeing this issue:
https://github.com/metabase/metabase/issues/23093 - upvote by clicking :+1: on the first post