Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Techies,
I have a use case where I need to create table chart in which week over week comparison is happening.
Suppose I have two columns in my table:
FiscalStartWeeek, Sales, WeekNO
1/2/2017 10 1
1/9/2017 24 2
1/16/2017 50 3
1/23/2017 23 4
..
..
..
6/3/2019 24 23
6/10/2019 34 24
and I want week over week result as as
FiscalStartWeeek, Sales, WoW%
1/2/2017 10 -
1/9/2017 24 24/10
1/16/2017 50 50/24
1/23/2017 23 23/50
...
..
6/3/2019 24 34/24
I have to keep firscalweekstart date in table
Thanks,
Rohit
You can use Above() function or you can do some script work ahead of time by using The As Of Table
I am not sure I am able to understand... can you share a sample where I can see the issue
Dear sunny,
I read your response on few ticket and found that we need to use AsOfWeekNo inline table to achieve
Week over week comparison.
Table chart must has date dimension and one other dimension for which we are calculating weekly growth.
I have made a sample qvw so you can help me to to calculate WOW.
I have created one AsofWeekNo, not sure it is required ,if yes the way I created is right, Please have a look and help me to achieve it.
Thanks,
Rohit
Check attached
Thanks for prompt response.
You are almost there , but only one thing is pending, I need to add date field in the chart you created, is it possible ? this is the point for which I created this ticket.
I am attaching updated qvw for you. Please use thing one.
Thanks,
Rohit
There are two charts in the attached app, which one are we looking at? Also, what is the output you are hoping to see from the sample provided? Can you provide this output in an Excel format?
Hi Sunny,
iI am attaching the sheet which has expected output. I am talking about the right one table which has comparison field and Asofweek field used.
I just need to bring date field into table corresponding to AsOfWeek . Kindly consider for more than 2 years i.e. 3 years. Sample data is only for 4 weeks.
Thanks,
Rohit
Okay that make sense. I think you needed an AsOfDate to go with your AsOfWeek field... This is as if you need a whole AsOf Calendar based on your AsOfDatefield. New Data model
and this is the chart that you wanted