topic Re: Format Date Dimension 'MMM YYYY' (QS April 18) in App Development

Format Date Dimension 'MMM YYYY' (QS April 18)

wdchristensen — Thu, 04 Oct 2018 18:57:37 GMT

I am trying to get my line chart to show the date as something like 'Jan 2018'. If I create a pivot table, I can get this representation by simply putting the formatting in the formula like: Date(MonthStart(DateOfEvent), 'MMM YYYY')

For some reason when I put this in the line chart it renders as m/d/yyyy. I suspect there a feature that is overriding my formatting but I am not sure where that setting can be changed. Ideally I would like to change the formatting at the object level and not the application level. Any help would be greatly appreciated! Thanks

Re: Format Date Dimension 'MMM YYYY' (QS April 18)

wdchristensen — Thu, 04 Oct 2018 20:06:37 GMT

I tried using:

Month("DateOfEvent")&'-'& Year("DateOfEvent") AS MonthYear

but that kills my sorting so I was considering loading:

Dual(Date(MonthStart(DateOfEvent), 'MMM YYYY'), Month("DateOfEvent")&'-'& Year("DateOfEvent") AS MonthYearDual

The hope is that I can use the text for the visualization and the number for the sort. I am resorting to the classic trial end error method. I thought that I should be able to use MonthYear in the visualization and just override the sort with a custom expression but for some reason when I apply a filter it scrambles the sort order. This seems like it should be a quick fix but it is turning out to be rather time consuming...

Re: Format Date Dimension 'MMM YYYY' (QS April 18)

merola_faria — Fri, 05 Oct 2018 13:02:20 GMT

Try using just :
MonthName("DateOfEvent") as MonthYear

It give you a date field in format jan 2018, fev 2018, etc, that you can use for visualization and sorting.