
1. Re: Need advice on a dashboard comparing 2 growth calculations
Adam Crahen Jun 21, 2016 1:07 PM (in response to d Vermaak)Hi Darren
Here a couple of ways to look at that data. I didn't clean them up so you could see how I did it.
9.3 attached.

Opened Stores1.twbx 822.3 KB


2. Re: Need advice on a dashboard comparing 2 growth calculations
d Vermaak Jun 21, 2016 1:46 PM (in response to Adam Crahen)Very interesting, thanks so much!!!
One question I did have was for our FY 2016, the year ends 7/31/2016, so we are still accruing injuries, hence the drop in %. How would I get around this? I don't want to filter out all of 2016 and I don't users to get the impression there has been significantly less injuries in 2016 either.
Secondly, injury % always seems to be higher than opened store %, so even though there are more injuries now than in 2012, it seems like it's staying fairly consistent (maybe even decreasing). So for the original question, can injury growth rate be accounted for by store growth rate, how would you answer this?
I'm just thinking outloud, but would it make sense to take the difference of injury growth and store growth?
For instance comparing 2014 and 2015:
You can see 2014 had a huge difference between store growth and injury growth, but in 2015, that number was much smaller. Does this make sense?

3. Re: Need advice on a dashboard comparing 2 growth calculations
Adam Crahen Jun 21, 2016 2:10 PM (in response to d Vermaak)Moderate positive relationship: Pearson r = 0.476
Some points are close to the line but other points are far from it, which indicates only a moderate linear relationship between the variables.
Interpret the key results for Correlation  Minitab Express
If you hover over the trend line on the scatter plot, you will see the p value is around .5. However, correlation is not causation.
Here is a view using the discrete month and year to show the injuries are increasing and that FY2016 is not complete.
I filtered out June 2016 because it was zero.
Differences YOY, but FY16 is partial year here.
9.3

Opened Stores1.twbx 900.7 KB


4. Re: Need advice on a dashboard comparing 2 growth calculations
d Vermaak Jun 21, 2016 2:51 PM (in response to Adam Crahen) 
5. Re: Need advice on a dashboard comparing 2 growth calculations
Adam Crahen Jun 21, 2016 3:33 PM (in response to d Vermaak)There doesn't appear to be. The points are scattered and not very close to the line.

6. Re: Need advice on a dashboard comparing 2 growth calculations
d Vermaak Jun 22, 2016 2:08 PM (in response to Adam Crahen) 
7. Re: Need advice on a dashboard comparing 2 growth calculations
Adam Crahen Jun 22, 2016 2:13 PM (in response to d Vermaak)Right click on the 2nd measure value pill and select dual axis. Right click on the right axis and select synchronize. Right click 2nd measure value pill and uncheck show header.

8. Re: Need advice on a dashboard comparing 2 growth calculations
d Vermaak Jun 22, 2016 2:34 PM (in response to Adam Crahen)Thank you!!!!