Forum Discussion
Week over Week Variance - Waterfall Charts
grantlee - Yeah, what I would do would be to create a column in your data like this:
Column = VALUE(CONCATENATE(LEFT([WW],4),RIGHT([WW],2))
This should give you a column like 201750, 201801, etc. as numbers. There is probably a way that you could do this where you would get sequential numbers, which would be even more awesome.
Hi,
What result are you expecting. Please show your result in a spare column.
Hi Ashish, I'm trying to look what changed each week or between two or more time periods for the demand. I guess what I'm trying to do is find the Week by Week changes or delta and be able to accummilate the deltas between time periods. I have more fields such as regions and tech that I would like to add in and be able to create slicers for filter on those. My example was for simplicity.
Greg_Deckler I agree, I think my WW as text might be what's causing an issue because I can't even use it. I can't find too many examples but it seems like most folks use WW as numeral (ie. 11 instead of WW11) I'm trying to dump in the year because I need to capture data in current and parts of last year and to avoid WW #s get mixed up. 2017-WW50 and 2018-WW01 will be in order but if I put 50 and 01 the 01 will be sorted first in any chart I create even though it should be at the end since it's really the newest week.
Do you recommend using the Quick Measure Variance? I tried to use it and seem to got some sort of result but the Variance shows $0.00 for each column.
grantlee - Yeah, what I would do would be to create a column in your data like this:
Column = VALUE(CONCATENATE(LEFT([WW],4),RIGHT([WW],2))
This should give you a column like 201750, 201801, etc. as numbers. There is probably a way that you could do this where you would get sequential numbers, which would be even more awesome.
Greg_Deckler Thanks Greg. I might have to do that and get rid of the "WW" in my raw data file as well. I never like to mix text and numbers together when it should be numeric in the first place.
