Names in Customer Service Dashboard
| # | Name | Definition | Purpose |
| 1 | lstAgents | =Data!$P$6:$P$11 | List of all unique Agents |
| 2 | lstProducts | =Data!$M$6:$M$11 | List of all unique Products |
| 3 | lstRegions | =Data!$N$6:$N$10 | List of all unique Regions |
| 4 | lstCtypes | =Data!$O$6:$O$9 | List of all unique Customer Types |
| 5 | lstCallDates | =INT(cs[Date Time]) | List of Call Dates - INT makes the time portion zero |
| 6 | lstCharts | =calcs!$J$2:$J$6 | List of all charts |
| 7 | lstChosen | =CHOOSE(calcs!$C$4, cs[Product],cs[Region], cs[Customer Type],cs[Agent ID]) | List of values chosen for comparison |
| 8 | lstMaxCallDurations | ='sp1'!$C$4:$C$31 | Maximum call duration by day |
| 9 | lstMinCallDurations | ='sp1'!$B$4:$B$31 | Minimum call duration by day |
| 10 | lstWaysToCompare | =Data!$M$5:$P$5 | List of ways to compare |
| 11 | lstWaysToCompareV | =calcs!$L$2:$L$5 | List of ways to compare (vertical) |
| 12 | rngSel1 | =Dashboard!$B$18:$D$23 | Range of options to compare on left side in dashboard view |
| 13 | rngSel2 | =Dashboard!$Q$18:$R$23 | Range of options to compare on right side in dashboard view |
| 14 | selChart | =CHOOSE(valChartToDisplay, calcs!$C$73:$H$81, calcs!$C$84:$H$92, calcs!$C$95:$H$103, calcs!$C$114:$H$122, calcs!$C$125:$H$133) | Selected Chart - range has the chart - used in picture link / camera tool output |
| 15 | selection1 | =calcs!$E$4 | Selected option #1 |
| 16 | selection2 | =calcs!$G$4 | Selected option #2 |
| 17 | valChartToDisplay | =calcs!$H$4 | Which chart to display |
| 18 | valHelpStatus | =calcs!$O$3 | Whether to display help or not |
| 19 | valOption1 | =calcs!$E$3 | Number of selected option #1 |
| 20 | valOption2 | =calcs!$G$3 | Number of selected option #2 |
| 21 | cs | =Data!$B$6:$K$14837 | Table of all call data. Dynamic. |