Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
markmm
Partner - Contributor
Partner - Contributor

Sorting Problem (Bar Chart)

Hi,

I have added a test application in which you see two charts (bar/straight table) sorted by a numeric date for that the weeks are in ascending order. the sorting works in in table, but in the bar chart (sort by expression)  it doesn't work. I don't know why?

thanks for answer

1 Solution

Accepted Solutions
stephencredmond
Luminary Alumni
Luminary Alumni

Hi Mark,

The problem here is that there is not just one Num.Date value for each week so the Sort expression will return multiple values and that is, essentially, null.

You need to return just one of the values so use Max or Min:

   max(Num.Date)

Regards,

Stephen

View solution in original post

3 Replies
Not applicable

Try sorting by numeric value.

stephencredmond
Luminary Alumni
Luminary Alumni

Hi Mark,

The problem here is that there is not just one Num.Date value for each week so the Sort expression will return multiple values and that is, essentially, null.

You need to return just one of the values so use Max or Min:

   max(Num.Date)

Regards,

Stephen

stephencredmond
Luminary Alumni
Luminary Alumni

Hi Mark,

You should mark the response as "Correct Answer".

Thanks,


Stephen