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

verytiredgirl
verytiredgirl Member
in Charting

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

Answers

  • ColemenWilson
    ColemenWilson Coach

    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.

    If I solved your problem, please select "yes" above

  • verytiredgirl
    verytiredgirl Member
    edited September 3

    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
    ColemenWilson Coach

    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?

    If I solved your problem, please select "yes" above

  • verytiredgirl
    verytiredgirl Member

    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:

    image.png

  • ColemenWilson
    ColemenWilson Coach

    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.

    If I solved your problem, please select "yes" above

  • ColemenWilson
    ColemenWilson Coach

    @verytiredgirl did you get this resolved?

    If I solved your problem, please select "yes" above

  • verytiredgirl
    verytiredgirl Member
    edited November 22

    @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 Year, it drill to branch level for that specific year, that's where the card title showing '2,023 Sales by Branch' appears

    image.png



Categories