Skip to main content

Trend Analysis

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.