Skip to content

Thousands separator can't be formatted #461

Closed as duplicate
Closed as duplicate

Description

@arturcarvalho

Hi there,

Probably another Vega related issue. If you prefer, I can not create any more of these Writer related tickets for the moment.

From what I can understand, it's not possible to get rid of the comma thousands separator.

If you try the attached basic.csv and try to format the Year breaks, it stays the same. According to Claude Code, this happens because "Vega's default formatter runs first, adding the thousand-separator". I couldn't find a workaround for this.

FROM basic
VISUALISE
DRAW point MAPPING Year AS x, Users AS y
SCALE x RENAMING * => '{:num %.1f}'
SCALE y RENAMING * => '{:num %.1f}'

Screenshot, should be "2016" instead of "2,016:
" Image
basic.csv

Activity

  1. teunbrand commented on Jun 3, 2026

    @teunbrand
    Collaborator

    Related problem is this:

    WITH data(x, y) AS (VALUES
      (1000, 1),
      (10000, 2),
      (100000, 3)
    )
    VISUALISE * FROM data
    DRAW point
    SCALE x 
      SETTING breaks => (1000, 10000, 100000)
      RENAMING 1000 => 'A'
    

    Where the first break is not 'A' but displayed as '1,000'.

    Changing to:

    RENAMING '1000' => 'A'
    

    Also keeps '1,000' instead of 'A'.

    Only when:

    RENAMING '1,000' => 'A'
    

    Does it change the label. It seems weird that the user would have to guess the way vegalite formats the labels before being able to set them.

  2. added
    bugSomething isn't working
    writerConcerns the writer arm of ggsql.
    on Jun 3, 2026
  3. teunbrand commented on Jun 9, 2026

    @teunbrand
    Collaborator

    I'm folding the thousand separator part into #470

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingwriterConcerns the writer arm of ggsql.

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions