DynamiteRave
New Member
- Joined
- Dec 7, 2017
- Messages
- 2
Hi everyone. I hit a brick wall and not sure what to do.
I'm using a Vlook up to track weekly trends of issue drivers, with a count of issues and an average of customer scores. So right now, my totals work just fine. It's the Score I can't seem to do. I attached the summary of what I'm doing and I'll attach an example of my data. For the counts, which works perfectly, I have this: =COUNTIFS(Data!F:F, "Delivery / Tracking",Data!A:A, Summary!C3) as an example. Week is Summary!C3 So when I change the week number, the data will change along with it. Pretty easy to do.
I just can't seem to figure out how to get the scores to average, by week, and by Issue. Any suggestions?
<colgroup><col style="mso-width-source:userset;mso-width-alt:5814;width:119pt" width="159"> <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:5266;width:108pt" width="144"> <col style="mso-width-source:userset;mso-width-alt:5193;width:107pt" width="142"> </colgroup><tbody>
</tbody>
Data:
<colgroup><col style="mso-width-source:userset;mso-width-alt:2925;width:60pt" width="80"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:2889;width:59pt" width="79"> <col style="mso-width-source:userset;mso-width-alt:17956;width:368pt" width="491"> <col style="mso-width-source:userset;mso-width-alt:4388;width:90pt" width="120"> <col style="mso-width-source:userset;mso-width-alt:5376;width:110pt" width="147"> </colgroup><tbody>
</tbody>
I'm using a Vlook up to track weekly trends of issue drivers, with a count of issues and an average of customer scores. So right now, my totals work just fine. It's the Score I can't seem to do. I attached the summary of what I'm doing and I'll attach an example of my data. For the counts, which works perfectly, I have this: =COUNTIFS(Data!F:F, "Delivery / Tracking",Data!A:A, Summary!C3) as an example. Week is Summary!C3 So when I change the week number, the data will change along with it. Pretty easy to do.
I just can't seem to figure out how to get the scores to average, by week, and by Issue. Any suggestions?
Week: | 43 | ||
Dates: | 11/19/2017 | 11/25/2017 | |
Issue | Score | Total | % of Feedback |
Delivery / Tracking | 1 | 13% | |
Inventory / DC Issue | 1 | 13% | |
Service / Agent Engage | 1 | 13% | |
Return / Exchange | 1 | 13% | |
Loyalty / Rewards | 1 | 13% | |
Discount / Promos | 1 | 13% | |
Change / Cancel | 1 | 13% | |
Order Verification | 1 | 13% | |
Total | 8 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:5814;width:119pt" width="159"> <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:5266;width:108pt" width="144"> <col style="mso-width-source:userset;mso-width-alt:5193;width:107pt" width="142"> </colgroup><tbody>
</tbody>
Data:
Week | Date | Score | Feedback | Order Number | Category |
43 | 11/21/2017 | 48 | Take time an listen | G006028861 | Delivery / Tracking |
43 | 11/22/2017 | 100 | My in store experience was horrible and embarrassing after a misunderstanding about my rewards Birthday coupon. The service involving this instore was really bad. But my call to customer service was very good and she made up for it | Not Populated | Inventory / DC Issue |
43 | 11/22/2017 | 0 | I requested a price matfch and was not given it on all items after being told that it was possible. | 6129290803 | Service / Agent Engage |
<colgroup><col style="mso-width-source:userset;mso-width-alt:2925;width:60pt" width="80"> <col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:2889;width:59pt" width="79"> <col style="mso-width-source:userset;mso-width-alt:17956;width:368pt" width="491"> <col style="mso-width-source:userset;mso-width-alt:4388;width:90pt" width="120"> <col style="mso-width-source:userset;mso-width-alt:5376;width:110pt" width="147"> </colgroup><tbody>
</tbody>