It seems that the
System Settings (app) > Analytics > “Default digit group separator to display in analysis module”
setting does not affect the Data Visualizer (such as Pivot tables) and uses a “Space” to separate digit groups, regardless of whether “Space”, “Comma” or “None” is selected.
Is this a known issue (I could not find a JIRA ticket)?
It seems that if the favorite was saved when the separator setting was set to a specific separator, it doesn’t update later on when the system is changed; however, the system setting is respected for all new visualizations. I did a quick test by creating a new visualization that uses a ‘simple calculation’ to get the values:
To change the separator in a favorite that was saved with another setting, you can change that from the Options > Style menu and then select the digit group separator. After changed that setting, save your favorite to keep the changes.
Thanks so much, really helpful and relieved that this is not a bug! I have updated all Pivot tables through the “Options” > “Style” > “Digit group separator” as you suggested.
I would suggest to include a note in the user documentation that the “Default digit group separator” only applies to visualisations configured after choosing this setting but does not apply to any existing visualisations (as I think this is not obvious, for example "Include zero data values in analytics tables does work “retroactively”).
It’s great to start CoP threads like these, and when there’s an improvement to the documentation, everyone is welcome to contribute to the docs. When viewing a documentation page, you can select at the top ‘edit’ icon which takes you to the repository and you can create a PR with the changes.