Forum Discussion
kurtrod
3 years agoFrequent Visitor
% 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...
kurtrod
3 years agoFrequent Visitor
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:
grantsamborn
3 years agoSolution Sage
Hi kurtrod
Can you double-check your dataset? It looks like [LY POS Qty] and [LY POS Sales] are reversed.
Grant