Skip to Content
0

Sorting week numbers in webi using merge

Feb 25, 2017 at 05:51 PM

75

avatar image
Former Member

Hi all,

I have merged 2 queries containing data usage by week number, one query gets last year and the other query gets the year before, so that I can have a YoY comparison chart. The merge was done on week number.

The problem is that the sorting of the weeks for the past year is 1,2,3,4,5,6,7,8,51,52,53 which includes Dec 2016. I need to sort the merged data set in such a way that it becomes 51,52,53,1,2,3,4,5,6,7,8.

Any ideas?

Thanks!

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

2 Answers

AMIT KUMAR
Feb 26, 2017 at 08:01 PM
0

have you tried to add year object & apply sort on Year object.After that hide the year object?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 27, 2017 at 07:15 AM
0

Hi Amit, thanks for your reply. Cannot do that since I have 2 merged queries, one for current year and one for previous year and therefore the years are different meaning they cannot be merged. This is really tricky and the only solution I've found is put a line graph on top of another one.

Share
10 |10000 characters needed characters left characters exceeded