PDA

View Full Version : comparison of kpi's from traffic reports of 4 diifferent days



simmus0300
2010-08-06, 01:58 AM
can anyone help how to do the comparison of kpi's from traffic reports of 4 diifferent days.

justdream
2010-08-06, 02:21 AM
what's the problem???

draw your KPI by using pivot table so you can have nice charts/ graphs

CMCCha
2010-08-06, 03:38 PM
can anyone help how to do the comparison of kpi's from traffic reports of 4 diifferent days.


have no DT data?

simmus0300
2010-08-07, 10:25 PM
what's the problem???

draw your KPI by using pivot table so you can have nice charts/ graphs

can you explain with a example ?
I want the following type of KPI comparison.

cell tch drop_0408 tch drop_0508 tch drop_0508 tch drop_0608
pba001a 5.3 4.7 4.8 5.1

similarly for other cells and for other KPIs

oswe
2010-08-07, 11:26 PM
can you explain with a example ?
I want the following type of KPI comparison.

cell tch drop_0408 tch drop_0508 tch drop_0508 tch drop_0608
pba001a 5.3 4.7 4.8 5.1

similarly for other cells and for other KPIs


you should spend some time with excel...
simply get the columns "cell_name", "tch_drop", "date"

then use a dynamic table where its source data is the data before mentioned.
--> rows: the cell_name
--> columns: the "date"
--> values: use your kpi (tch_drop) in this case.

make 1 dynamic table for each kpi then you can change column titles

youll have:
cell_name date1 date2 date3 date4
bar1_a 1.4 1.6 1.7 2.4 2.67
bar1_b 0 0 0 0
bar1_c 0 0 0 0

simmus0300
2010-08-08, 02:11 PM
you should spend some time with excel...
simply get the columns "cell_name", "tch_drop", "date"

then use a dynamic table where its source data is the data before mentioned.
--> rows: the cell_name
--> columns: the "date"
--> values: use your kpi (tch_drop) in this case.

make 1 dynamic table for each kpi then you can change column titles

youll have:
cell_name date1 date2 date3 date4
bar1_a 1.4 1.6 1.7 2.4 2.67
bar1_b 0 0 0 0
bar1_c 0 0 0 0

dear,
can you explain more clearly how to make dynamic table ?. i have four excel sheets each consisting of cell name,tch drop,H/O fail etc. There is no date field.