Sort issue with bar chart and display results in "=Day & ' - ' & Month"

[#1]

My default date format = DD-MMM-YYYY (01-Jan-2010.

I Have a Calendermaster table with:

%Calenderday (DD-MMM-YYYY)

Year

Month (Jan-Dec)

Week

Day

Now i want to show my result in a bar chart with "=Day & ' - ' & Month" between a date. This is working so far. But now i have a problem with Sorting the results.

On default i get these results:

i tried expression sorting on "=Day".

This works when there is not a bigger timespan selected then 1 month. But when there are more months selected, you see the results like this

I also tried sorting on "=Day & ' - ' & Month" But then i get results like this

I even tried sorting on %Calenderday. But then the results look like this

Some advice is welcome here

Thanks a lot!

[jvitantonio]

Hi, please create a new filed in your script like this:

date(%Calenderday, 'DD-MMM') as DayMonth

You this in your charts and order by this field.

Hope this helps.

[#3]

I know this would be a solution. But is there no other way then alter my datamodel or add code to my current report?

[jvitantonio · Accepted solution]

No because you concatenate 2 fields and this is no longer a date field,. You can try

date(makedate(Year, Month, Day) , 'DD-MMM')

[jvitantonio]

Here's an example:

[#6]

Thanks a lot! This trick Seems to do it. But the performance goes down a lot.

So i have changed my Datamodel instead with your first solution. Seems to be faster.