How do I add a Field to the 'Card Title' or 'Description' even if it is not a card filter?

Roman_K

I have successfully added Year (2023) & Category (111, 123, 132, 134) to 'Description' to my card (screen shots) because they are user filters. Is there a way to add, for example, Current Page (also shown below), even if it is not a filter? Also, when the data is exported to excel, Year (2023) & Category (111, 123, 132, 134) do not show up in a header. Is there a way to adjust so that the selected Year(s) and Categories do populate in the excel file when exported, as well as today's current date?

DavidChurchman

One other place you can add text from fields is in the summary number. Nice thing about the summary number is you can apply HTML formatting (or not) with a BeastMode. There are some kind of ugly examples of that here, but you get the idea:

https://domo-support.domo.com/s/article/360043430093?language=en_US

One thing that is impossible in a BeastMode (as far as I know) is to reference strings across different rows of your data. So I don' think you'll be able to create a list of Current Pages like "68, 14, 56", but you could reference the most frequent, the average, the __ Current Page with some clever sorting/beastmoding.

brycec

There isn't a way to add a field without it being a filter to smart text. You could add it as a filter, and select all, to add it.

There also isn't a way to add smart text to an Excel export unfortunately. I like that feature idea, you should create a post in the ideas exchange to start getting the product team to look at it.

DavidChurchman

One other place you can add text from fields is in the summary number. Nice thing about the summary number is you can apply HTML formatting (or not) with a BeastMode. There are some kind of ugly examples of that here, but you get the idea:

https://domo-support.domo.com/s/article/360043430093?language=en_US

One thing that is impossible in a BeastMode (as far as I know) is to reference strings across different rows of your data. So I don' think you'll be able to create a list of Current Pages like "68, 14, 56", but you could reference the most frequent, the average, the __ Current Page with some clever sorting/beastmoding.

brycec

Oh, great point @DavidChurchman! Even better, there is a way to add all those Current Pages to the Summary Number. Simply use the LISTAGG(`Current Pages`) and you should be set! There is no way to adjust the LISTAGG separator, but you could just do REPLACE(LISTAGG(`Current Pages`), ',', ', ') to change it to have a space after the comma or you can adjust that Beast Mode accordingly to have any separator you want.

DavidChurchman

@brycec LISTAGG is a new one for me, thank you! I played with it, and it also works with DISTINCT, so I'll add that to your suggestion:

REPLACE(LISTAGG(DISTINCT `Current Pages), ',', ', ')

Roman_K

Thank you both for the help.