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:

ColemenWilson

What is the field used in the smart text? Is it a date field? I see, for example, that ship_date is not a date, but an integer or text.

ColemenWilson

@verytiredgirl did you get this resolved?

verytiredgirl

@ColemenWilson no, not yet.

So I have a multi-lines charts with x-axis = ship_date, y-axis = sales, series = province → drill to line chart as well with same x and y-axis but series = branch. The date range for both cards are Feb 1, 2023 - Sep 30, 2024, by YEAR

*the ship_date column formatted as 'yyyy-mm'dd'

When you click on a line chart of a specific Month, it drill to branch level for that specific month, that's where the card title showing '2,023 Sales by Branch' appears