
1. Re: Graphing data
Deepak Rai Jul 3, 2018 12:47 PM (in response to Ryan Tanaka)Can you explain the requirement with some sample? It is confusing

2. Re: Graphing data
Ryan Tanaka Jul 3, 2018 10:28 PM (in response to Deepak Rai)For example,
If I have an x&y data chart, and on the y axis is how many cups of lemonade I have sold in June 2018 ( 1 dot equals 1 day) and on the x axis I have how many cups of smoothie I have sold in June 2018, how would I write a formula to get the data from 2017 smoothie's sales and 2018 lemonade's sales on the same graph . One example of this is, the data from June 29 2018 gets turned into the data from June 30 2017 (so you subtract 364 days). I'm trying to understand if the 2017 smoothie sales are correlated to the 2018 smoothie sales. Please let me know if you have an answer. Thanks!

3. Re: Graphing data
Peter Fakan Jul 3, 2018 10:34 PM (in response to Ryan Tanaka)Hi Ryan,
LOOKUP(SUM([sales])1)
This will work if your aggregation is at the year level, if it is at the month level then you will need to do;
LOOKUP(SUM([sales])12)
HTH
Peter

4. Re: Graphing data
Ryan Tanaka Jul 10, 2018 7:49 PM (in response to Peter Fakan)Hi Peter,
I tried your code and it didn't work. Do you have any other ways you think I could get the data that I need.

5. Re: Graphing data
Peter Fakan Jul 10, 2018 7:51 PM (in response to Ryan Tanaka)Hi Ryan,
Can you upload a sample data set please ?
Peter