Attention: Experience League Community will undergo scheduled maintenance on Tuesday, August 20th between 10-11 PM PDT. During this time, the Community and its content will not be accessible. We apologize for any inconvenience this may cause.
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
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
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.
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.
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.
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.
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.