cancel
Showing results for 
Search instead for 
Did you mean: 

Sorting week numbers in webi using merge

0 Kudos

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!

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

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.

amitrathi239
Active Contributor
0 Kudos

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