Skip to Content
0

Calendar Week/Cal Month sorting in Lumira 1.31

Feb 01, 2017 at 07:49 PM

128

avatar image

Hi,

We have created a couple charts in Lumira 1.31.3 and have noticed that when we drop 0CALWEEK/0CALMONTH (datasource is BEx query) into the chart on the x or y axis, that the weeks aren't getting sorted properly.

For example, if we have two years of data and I drop 0CALWEEK into the x axis, the output is like this...

01/2016

01/2017

02/2016

02/2017

Looks like Lumira doesn't even recognize these as time characteristics. Furthermore, there is no option in the sort to sort by calweek/year or calmonth/year - just by day.Whereas I'd obviously rather sort like this

01/2016

02/2016

....

52/2016

01/2017

02/2017

Is this a product limitation or is there a trick to get this working properly?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Tammy Powlas
Feb 01, 2017 at 09:47 PM
0

Varun has some work-arounds mentioned in this link: https://archive.sap.com/discussions/thread/3943825

The link also has ideas in Idea Place.

Share
10 |10000 characters needed characters left characters exceeded