Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Exponential change in data on a graph by week

So Basically I have a starting Stock situation.

I have a table with events that impact the stock every week (by weeknumber)

With a simple measure I calculate the starting stock situation and get an end result on how much stock I have by the end of all the weeks.

 

The result is correct, however if I try and add it to a graph while adding the weeknumbers of the impact it will give me the original stock and the impact of that week without caring for the chance of the previous week.

 

So week 1 it will calculate the stock correctly, but week 2 the result will be Original stock -+ impact of week 2 instead of results of week 1-"X" +- impact current week.

 

So how can the graph increase or decrease exponentially?

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Anonymous ,

     

    Not very clear about your desciption, could you please share some sample data and show the expected result for further test?

     

    Regards,

    Jimmy Tao

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      So the "Graph" below is the result of the stock situation in W1 with the impact of 29 weeks, the end result is correct I've double checked that

      Now in my data I have a collum that indicates what week the impact is from, when I apply this to the Axis of this graph I expect to see the stock changes week by week, but this is my result, instead of seeing my data change week by week it just compares the original stock data with what happened in "THAT" week so the end result here is the original stock +- the impacts of week 29 not caring for the previous 28 weeks.