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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Time/Date Formats when exporting Data to Excel

Avatar

Avatar
Boost 5
Level 2
m-spencer
Level 2

Likes

14 likes

Total Posts

7 posts

Correct reply

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

Avatar
Boost 5
Level 2
m-spencer
Level 2

Likes

14 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
m-spencer
Level 2

01-04-2015

When saving reports from both Adobe Analytics and more importantly, Adobe Ad-Hoc Analytics would love to see that any date/time dimention on a report is formatted correctly on the Excel Spreadsheet to allow for easily sorting/ordering etc.

 

For example, when running a Ad-Hoc report broken down by various months over a long time period, I want to be able to display this in date order (Which isn't possible in Ad-hoc to sort by the dimention at present). As these aren't date formatted for Excel, I have to manually move each row of this report to show the months in the correct order which is a time consuming process.

8 Comments

Avatar

Avatar
Springboard
Level 6
stefanies325986
Level 6

Likes

140 likes

Total Posts

109 posts

Correct reply

0 solutions
Top badges earned
Springboard
Establish
Contributor 2
Give Back 25
Ignite 10
View profile

Avatar
Springboard
Level 6
stefanies325986
Level 6

Likes

140 likes

Total Posts

109 posts

Correct reply

0 solutions
Top badges earned
Springboard
Establish
Contributor 2
Give Back 25
Ignite 10
View profile
stefanies325986
Level 6

20-04-2015

Hi,

I agree with you, this is annoying and kind of silly to have a date as text format. I created a formula workaround with vlookup...

Clientcare says this is a feature, not a bug!

Thanks for posting the idea.

Regards

Stefanie

Avatar

Avatar
Give Back 5
Level 2
gary_mason
Level 2

Likes

3 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile

Avatar
Give Back 5
Level 2
gary_mason
Level 2

Likes

3 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
gary_mason
Level 2

01-06-2015

Hi,

 

I have seen this problem too and could only fix it by inserting a column in Excel to run the date through an IF/VALUE/TEXT style formula to change the formatting.

Avatar

Avatar
Springboard
Level 6
stefanies325986
Level 6

Likes

140 likes

Total Posts

109 posts

Correct reply

0 solutions
Top badges earned
Springboard
Establish
Contributor 2
Give Back 25
Ignite 10
View profile

Avatar
Springboard
Level 6
stefanies325986
Level 6

Likes

140 likes

Total Posts

109 posts

Correct reply

0 solutions
Top badges earned
Springboard
Establish
Contributor 2
Give Back 25
Ignite 10
View profile
stefanies325986
Level 6

01-06-2015

Hi Gary,

would you mind sharing the exact formula?

Regards

Stefanie

Avatar

Avatar
Boost 5
Level 3
_jm_97660
Level 3

Likes

36 likes

Total Posts

36 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 3
_jm_97660
Level 3

Likes

36 likes

Total Posts

36 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
_jm_97660
Level 3

04-06-2015

Hi @Stef @Gary @Michael_Spencer

 

You should be able to sort by date/month if you change the 'Font and Locale' settings under Tools > Settings in AdHoc Analysis to English (International).

 

FontLocale.png

 

ExcelFromAdHoc.png

Avatar

Avatar
Boost 5
Level 2
m-spencer
Level 2

Likes

14 likes

Total Posts

7 posts

Correct reply

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

Avatar
Boost 5
Level 2
m-spencer
Level 2

Likes

14 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
m-spencer
Level 2

30-07-2015

@_JM_

 

I did what you suggested above however on export it was still formatted as a text field.

Avatar

Avatar
Springboard
Level 6
stefanies325986
Level 6

Likes

140 likes

Total Posts

109 posts

Correct reply

0 solutions
Top badges earned
Springboard
Establish
Contributor 2
Give Back 25
Ignite 10
View profile

Avatar
Springboard
Level 6
stefanies325986
Level 6

Likes

140 likes

Total Posts

109 posts

Correct reply

0 solutions
Top badges earned
Springboard
Establish
Contributor 2
Give Back 25
Ignite 10
View profile
stefanies325986
Level 6

11-02-2016

Hi JM,

for me it does not work either... Maybe you are using another version of Excel?

Avatar

Avatar
Boost 5
Level 3
_jm_97660
Level 3

Likes

36 likes

Total Posts

36 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 3
_jm_97660
Level 3

Likes

36 likes

Total Posts

36 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
_jm_97660
Level 3

11-02-2016

Hi Stef,

 

Sorry if it is not working. For me and my colleagues it worked by just changing the locale.

I am using Excel 2010 (Windows)

 

Attached is the screenshot from Discover for both locales. The only thing I did was changing the locale and restarting Discover. As you can see here, the date format is automatically changed to the Excel friendly dd-mmm-yyyy format

 

Please note that if you are using International locale then you might not see the segments,metrics,dimensions etc due to a recent bug in Java/Discover

More details here: Known issue with Ad Hoc Analysis and Java 8 Update 71

Avatar

Avatar
Springboard
Level 6
stefanies325986
Level 6

Likes

140 likes

Total Posts

109 posts

Correct reply

0 solutions
Top badges earned
Springboard
Establish
Contributor 2
Give Back 25
Ignite 10
View profile

Avatar
Springboard
Level 6
stefanies325986
Level 6

Likes

140 likes

Total Posts

109 posts

Correct reply

0 solutions
Top badges earned
Springboard
Establish
Contributor 2
Give Back 25
Ignite 10
View profile
stefanies325986
Level 6

11-02-2016

Hi,

by the way: when exporting from data warehouse, it is also not working for me.

There is simply text, i.e. "December 2015".

BR