8 Replies Latest reply on Dec 8, 2016 3:39 PM by Tiffany Kinson

# Highlighting Changes within a Time fence

Hello,

I am trying to highlight when a product's demand increases within it's provided time fence. Here is how i have my workbook set up currently.

Extent of Lead Time is the date that I am trying to see if there was a large increase within.

Does anyone have some good tips on how to organize my workbook to visualize that change?

• ###### 1. Re: Highlighting Changes within a Time fence

Tiffany,

You look like blending data source and it's quite difficult to understand your issue without seeing your data set.

Could you attach packaged workbook, please?

Thanks,

Shin

• ###### 2. Re: Highlighting Changes within a Time fence

Hi Shin,

Thanks for responding and offering to help!

Here is my packaged workbook attached.

Thanks,

Tiffany

• ###### 3. Re: Highlighting Changes within a Time fence

Which numbers you are trying to compare against which number?

And what is the criteria of large increasing?

Thanks,

Shin

• ###### 4. Re: Highlighting Changes within a Time fence

What I'm ideally trying to do is show is when a demand increases by 150% within the time fence.

So for example in the first example, I;m comparing October forecast against November forecast. (it only shows one value right now because i have a table calc showing the difference between the two period of's).  I want to show if it increases by 150% within the time fence which is I believe February for the first SKU.

• ###### 5. Re: Highlighting Changes within a Time fence

I'm still not exactly sure I'm on right track or not, anyways.

Here is a formula to distinguish more than 150% increase.

[Final Forecast Color]

if ((ZN(SUM([Final Forecast])) - LOOKUP(ZN(SUM([Final Forecast])), -1))

/ ABS(LOOKUP(ZN(SUM([Final Forecast])), -1))) >1.5

then "Red" else "Green" end

Thanks,

Shin

• ###### 6. Re: Highlighting Changes within a Time fence

Hi Shin,

You are on the right track! Thank you for providing this.

For the first item on the worksheet - 00CAT00599, how would I get it to only show values or percentage change through February 2017. That is the time fence of the product, and so anything outside of that is irrelevant.

Do you have any tips no that?

Thank you so much!

Tiffany

• ###### 7. Re: Highlighting Changes within a Time fence

I'm not sure how you difine time fence.

You can filter month/year with this field, though.

Thanks,

Shin

• ###### 8. Re: Highlighting Changes within a Time fence

Thanks!

Yep, I understand how to filter for specific dates through that application. But what I'm trying to see is just the "Extent of Lead Time" and the "Period For".

So for example, if the item A has Extent of Lead Time of March 2017, then it would only show Period For through March 2017. And then if item B has Extent of Lead Time of April 2017, then it would only show Period For through April 2017. But both items on the same worksheet.

Does that help to clarify?

Thank you!

Tiffany