Week over Week Report

Lyn Balberde shared this question 50 days ago
Answered

Hello!


I need to create a Week over Week report, however what I can only see is the Year over Year through subquery. Can anyone suggest a workaround for me to make it possible?


Thank you. :)

Comments (4)

photo
1

Hi Lyn,


Thanks for your message.


I'm a little unsure what you mean by Week over Week, would you mind clarifying what you mean by providing an example?


Once I get an understanding of what you are after, I should be able to point you in the right direction.


Kind regards,

Simon

photo
1

Hi Simon,

I already prepare my dataset as like this:

Week | Income

35 | 20,000

36 | 30,000

37 | 45,000

I want my report to have a filter of week number and my report would give me the income of the chosen week, its previous week, percentage  change.

Example the filter I chose is Week 36, the report would give me:

Current Week: 30,000

Previous Week: 20,000

Percentage Change: 33%

On Fri, Oct 15, 2021, 7:18 AM Yellowfin Support, <support@yellowfin.bi> wrote:

photo
1

Hi Lyn,


I encourage you to explore the resources at Yellowfin University to get a better understanding of Yellowfin's capabilities, so that you can explore these yourself. Questions such as this one are answered through the training provided there.


It sounds like you are changing your data from a Narrow Format to a Wide Format. This can be achieved by using Append Subqueries, and linking the filters for each subquery to the master query so that they are dynamic.


This would be the filter for your Main query, except instead of Last 3 months it would be Last calendar week / Last business week:


/88b826ddc1fbdfdfe766a6593187f103


This would be the filter for your subquery, linking to the Main query. In your example it would be -1 week:


/56e7cd69bfb34fbccadce7b80a8db8e3


Your Report would now have two time periods, linking together so that any change to the Main query also changes the subquery, which is trailing the main query by 3 months (in my example).


/1bd1fc81773733068fbd7d79cc77da4f


You can then apply an Advanced Function: Percentage Change against Column for the Current Period, or you can drag the same column in if you want the value as well as the percentage change:


/974b251dac701f732c1e7518b61ca09a


You can then add Conditional Formatting and other Column Formatting as you desire (i.e. changing the font to red, adding an downward arrow icon for a decrease, adding a percentage sign etc). You can also hide the column from the subquery if you don't want to show that in Reports:


/48e4bbdcb4869de25bdf8fa11eb5eb51


As I mentioned earlier, these types of Report creation tasks are all covered in Yellowfin University.


Let me know if you have any further questions.


Kind regards,

Simon

photo
1

Hi Lyn,


I'm just messaging to let you know that I am marking this as answered for the moment.


Please feel free to reach out if you have any further questions and I'll get back to you shortly.


Kind regards,

Simon