Trend Analysis
Anthony.Kariuki
Forums
I test the use of cards and get the below results.
Monday
W_CARD_FLAG
NO_OF_RECS
NO_OF_RECS_PERCENT
NETWEIGHT_SUM
NETWEIGHT_SUM_PERCENT
STATUS
0
1051
47.41
9123.800
47.83
NO CARD USED
1
1166
52.59
9953.000
52.17
CARD USED
Tuesday
W_CARD_FLAG
NO_OF_RECS
NO_OF_RECS_PERCENT
NETWEIGHT_SUM
NETWEIGHT_SUM_PERCENT
STATUS
0
3000
30.00
302005.00
30.00
NO CARD USED
1
7000
70.00
795953.000
70.00
CARD USED
How would I go about showing a trend of cards used for a period like daily or weekly or monthly? Like for the case above an increse from 52 to 70 from Monday to Tuesday.