how to make text box dynamic

I have a dimension product_name, and my requirement is that in dashboard I want to show user with the text: “Hello ABC, this month your most sold product is XYZ”.

I am able to achieve text: “Hello, ABC” in a tile by using dummy dimension, how can I do the same in text box component (is this even possible that we can add some dimension in text box ?):

9236c137-ee72-47da-9b88-57a9476ea470.png

Second thing is that How to find most sold product using LookML so that I can add that into my text box, I know that using SQL I can achieve this but how to implement same using LookML.

0 3 2,877
3 REPLIES 3
Top Labels in this Space
Top Solution Authors