Week by Year hierarchy

[Keyur Parekh 3]

Hi Experts,

I have a bar graph showing weekly trend and I want to use a category axis zoom slider to be able to show last 6 months of data.

I see that there are options available that you could select to convert Year > QTR, Year > QTR > Month however I do not see a way to do Week > Year.

How can I convert the attached visual to reflect weeks and year so that I could show Aug18 though Jan19 trend by week by year.

Appreciate your time.

Thanks,

Arpitha

[Khushboo Rabadia]

It is not available directly but you can form it in custom expression like :

 

If you want Week first then Year, reverse it in above expression like

[Keyur Parekh 3]

Thank you so much Khushboo :)