05-12-2015 10:13 AM
I need some assistance on this metric. The metric contains CustID, # of flags for 2015Q1, 2014Q4 & 2014Q1. How can I show numerical trends current quarter to prior quarter and current quarter to a year ago. My metric look like this
Thanks in advance for your help.
05-13-2015 05:03 PM
More info please. When you say you want to show the trend, do you mean you want to model the trend or explain the trend?
Or is this just a visualization exercise? what are you trying to do?
05-13-2015 09:05 PM
what i am trying to show base on the # of flags for each client if the # of flags trending upward or downward without using visualization.I will welcome any suggestion on this.
05-13-2015 09:56 PM
Do you want to calculate the trend for each CustID?
Year_Trend = 2015Q1_flags - 2014Q1_flags
Qtr_Trend = 2015Q1_flags - 2014Q4_flags
Or are you looking for a statistical test, that shows whether there is a trend? (Paired T-test)