Skip to content

    • Charting

    Charting

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

    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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Answers

    • Coach

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

      1. yourField * 1

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

      Another option is: 

      1. 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

    • Member
      edited September 2024

      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')

    • 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

    • 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
    • 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

    • Coach

      @verytiredgirl did you get this resolved?

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

    • Member
      edited November 2024

      @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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories