Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Change decimal and thousand separator in Ad Hoc Analytics

Avatar

Avatar
Validate 1
Level 2
thomas_løjmann2
Level 2

Likes

3 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
Applaud 50
View profile

Avatar
Validate 1
Level 2
thomas_løjmann2
Level 2

Likes

3 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
Applaud 50
View profile
thomas_løjmann2
Level 2

03-11-2014

Hi,

 

In Adobe Analytics you can change the decimal and thousand separator, but Ad Hoc keeps the default (US) settings, making it hard to copy data directly from Ad Hoc into Excel for analysis, as you then have to replace all commas with dots (for example) and as my Excel reads comma as a decimal separator, figures like 1,120 will be change to 112 etc...

 

The decimal and thousand separators must be aligned across all systems, and Admin's should have the opportunity to change the default separators for everyone or at least per user-group.

 

/Løjmann