Smart Text card title show year with a comma. How do I get rid of it?

verytiredgirl

So instead of '2024 Sales', the title shows '2,024 Sales'. How do get rid of this comma?

I used 'Display any filter' Sales as Card Title

ColemenWilson

Try creating a beastmode for the field that has the 2,024 value:

yourField * 1

And then use that as the filter for the card and the comma should disappear.

Another option is:

REPLACE(yourField,',','')

The other option is to change the data type of the field in Magic ETL to an integer.

verytiredgirl

Would this work if my Field/Column is a Date column with a format yyyy-mm-dd? I was able to do the BeastMode 'Date*1' but then I couldn't use that Date column for card visuals.

P/S: I have Sales trend over year —> drill down sales to a specific year (that's where the drill down card title show '2,024' instead of '2024')

ColemenWilson

Oh interesting, I thought your values were just: 2023, 2024, etc… I didn't realize they were in date format. Could you provide a screen recording of what you are seeing along with the underlying fields?

verytiredgirl

the data is a bit sensitive but I can show you card the title after I drilled down sales to a specific year for a particular region: