Parameter Setting -- Month & Year

tableaucommunity@tableau.com — Wed, 30 Jan 2013 00:26:55 GMT

Good Day,

Within our report, we have a parameter to select a break-out by dates. Worked perfectly with the following formula: Datename('month',[sales date]). However, I completely forgot about the the new year...

With the old method, it would read:

October

November

December

New year -- I know have: January - October - November - December.

To address the issue, I added: Datename('month',[sales date]) + " " + Datename('year',[sales date]) Format it works perfectly -- sorting, not so much.

Now our data is sorted alphabetical.

Anyone had a pretty good solution for address the sort within a Date & Year Parameter?

Thank you in advance for the support & assistance.

Content in Tableau Community Forums

Parameter Setting -- Month & Year