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

Fix Granularity Representation on Export

Avatar

Avatar
Ignite 10
Level 4
jharrington7897
Level 4

Likes

66 likes

Total Posts

50 posts

Correct reply

2 solutions
Top badges earned
Ignite 10
Give Back 25
Ignite 5
Give Back 10
Give Back 5
View profile

Avatar
Ignite 10
Level 4
jharrington7897
Level 4

Likes

66 likes

Total Posts

50 posts

Correct reply

2 solutions
Top badges earned
Ignite 10
Give Back 25
Ignite 5
Give Back 10
Give Back 5
View profile
jharrington7897
Level 4

20-07-2018

1532214_pastedImage_0.png

Could you guys get this on the roadmap?  It's hard to share a project with someone in workspaces if they have to figure out what month 10/29/18 is on a fiscal calendar

9 Comments

Avatar

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile
jen_lasser
Moderator

13-08-2018

Can you elaborate more around what your example is showing, and what the desired behavior is? Thanks!

Avatar

Avatar
Ignite 10
Level 4
jharrington7897
Level 4

Likes

66 likes

Total Posts

50 posts

Correct reply

2 solutions
Top badges earned
Ignite 10
Give Back 25
Ignite 5
Give Back 10
Give Back 5
View profile

Avatar
Ignite 10
Level 4
jharrington7897
Level 4

Likes

66 likes

Total Posts

50 posts

Correct reply

2 solutions
Top badges earned
Ignite 10
Give Back 25
Ignite 5
Give Back 10
Give Back 5
View profile
jharrington7897
Level 4

13-08-2018

Sure thing -

In the example above, Feburary of 2017 are the dates 1/29/17 - 2/25/17 for a fiscal calendar.

If you create a report (like on the left) of say sales broken down by month,  and then you export that report to a CSV, the output, rather than being labeled as "Feb 2017" is actually the starting date of February.

This makes it challenging to work with this data, as you can have a date which "appears" to be February (2/26/17) but is actually March.

The desired output would be the label "Feb 2017" (same as the report) rather than 1/29/17

Avatar

Avatar
Contributor
Level 2
ericb69243940
Level 2

Likes

2 likes

Total Posts

14 posts

Correct reply

1 solution
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Contributor
Level 2
ericb69243940
Level 2

Likes

2 likes

Total Posts

14 posts

Correct reply

1 solution
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile
ericb69243940
Level 2

16-08-2018

Il not sure I get the desired behaviour in detail but I may have similar issue.

Basically our fiscal months are cut off 3 business days prior to end of calendar month.

so fiscal August 18 for example starts 27th of July.

I guess the desired behaviour here would be to be able to define a specific « fiscal month » dimension where « August FY18 » would be July 27t-August 28th. Am I right ?

If yes, I’d be interested into this as well, but not for replacement of the standard calendar month dimension, more as a second option because not all our business users want to use the fiscal view.

Eric

Avatar

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile
jen_lasser
Moderator

20-08-2018

We are looking into this one. We would like to show the month in the CSV as a text string, just like it is displayed in Workspace. It would show "Feb 2017 (Jan 29-Feb 25)" in this case.

Would that work for both of your use cases? jharrington7897ericb69243940jharrington7897

Avatar

Avatar
Ignite 10
Level 4
jharrington7897
Level 4

Likes

66 likes

Total Posts

50 posts

Correct reply

2 solutions
Top badges earned
Ignite 10
Give Back 25
Ignite 5
Give Back 10
Give Back 5
View profile

Avatar
Ignite 10
Level 4
jharrington7897
Level 4

Likes

66 likes

Total Posts

50 posts

Correct reply

2 solutions
Top badges earned
Ignite 10
Give Back 25
Ignite 5
Give Back 10
Give Back 5
View profile
jharrington7897
Level 4

21-08-2018

Yep - that would be much better,and makes more sense

On Mon, Aug 20, 2018 at 4:58 PM, jen.lasser <forums_noreply@adobe.com>

Avatar

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile
jen_lasser
Moderator

23-08-2018

If we made this change, it would change the field in the CSV to text format, which means it would no longer be sortable. Does that pose a problem for how you use those exports? Or would you still prefer text strings in there?


The other option is to add an additional column with the text string. We think that might not be ideal though because it would through off any references to the table.

Let me know what you think!

Avatar

Avatar
Ignite 10
Level 4
jharrington7897
Level 4

Likes

66 likes

Total Posts

50 posts

Correct reply

2 solutions
Top badges earned
Ignite 10
Give Back 25
Ignite 5
Give Back 10
Give Back 5
View profile

Avatar
Ignite 10
Level 4
jharrington7897
Level 4

Likes

66 likes

Total Posts

50 posts

Correct reply

2 solutions
Top badges earned
Ignite 10
Give Back 25
Ignite 5
Give Back 10
Give Back 5
View profile
jharrington7897
Level 4

23-08-2018

Thanks for the feedback Jen - the sorting is a pretty easy fix in excel.

It's more challenging if a new user  pulls a monthly report, and gets an output like "05/06/18", and have to explain to someone that that signifies the month of May, that it isn't something that was pulled by day with a bunch of missing days etc.

Where a user can see "May (May 6 - June 2)" and know what they're looking at.

Avatar

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile
jen_lasser
Moderator

31-07-2019

Marking this as "For Future Consideration".

Earlier this year, we made updates to our CSV exports to remove all formatting, so that CSVs remained focused on raw data only. That way, end users can apply any formatting that they need. This request falls into the "formatting" category, instead of a "data" category.

Avatar

Avatar
Ignite 10
Level 4
jharrington7897
Level 4

Likes

66 likes

Total Posts

50 posts

Correct reply

2 solutions
Top badges earned
Ignite 10
Give Back 25
Ignite 5
Give Back 10
Give Back 5
View profile

Avatar
Ignite 10
Level 4
jharrington7897
Level 4

Likes

66 likes

Total Posts

50 posts

Correct reply

2 solutions
Top badges earned
Ignite 10
Give Back 25
Ignite 5
Give Back 10
Give Back 5
View profile
jharrington7897
Level 4

31-07-2019

Sounds Good, thanks Jen!