Forum Discussion
% change average for Graph with multiple weeks
Hi everyone, I am trying to get an average of YoY at weekly level to plot in a graph. When I plot it in the graph, it doesn't turn out correctly due to all of the zeroes where I had no sales last...
Hi kurtrod
Just a couple of questions
1 - What type of graph did you want? (I'm just trying to picture your expected end result.)
2 - The sample data is for 42 stores but just 1 week. Is there any way you can come up with more sample data that makes sense? (I've tried to come up with random data for a 6 week period but the numbers obviously wouldn't make any sense.)
Let me know if you have any questions.
Here is a link to a full data set for this one item. I have several items in my actual dataset:
Here is what I am trying to produce:
Hi kurtrod
Can you double-check your dataset? It looks like [LY POS Qty] and [LY POS Sales] are reversed.
Grant