Hello all, I am trying to build a QuickSight matrix table that counts the voice of customers (VOC) by customer segment. I want to do the following as illustrated by the attached image:
Use three fact tables that contains unique VOC data. There are three different sources of VOC: one VOC table per source.
Use a single table that contains customer data.
Join three VOC tables and customer table through customer ID.
In the dashboard, use calculated field to add the count of VOCs of three different sources to demonstrate an overall count.
However, I am having a hard time figuring out how to do this. Will there be any way that I can do this? Your advice would be highly appreciated.
Naveed is right. Since you want metrics by Customer segment and have three different fact tables you need to run this through the Customer since you may or may not have data for a customer in all three fact tables for the same details (dates etc).
So if you have Customer on the Left side of the join and have the fact tables to the rightside of the join then I think it should work for you.
Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!
@Naveed@Giridhar.Prabhu Thank you for the answers. I apologize for the late reply. I tried the following as advised:
Customer on the left side
VOCs on the right side
left join (join through “customer ID”).
However, it did not work well. The count of VOCs per customer/customer-segment becomes larger than the actual count. This is because some “customer ID” appears multiple times on the right side (i.e. some customers have raised multiple VOCs). If you could let me know if I am missing something, that would be highly appreciated.
You can try the distinct count function this will return you the actual result.
One more thin you need to group the customer id and use value for the rest of the column.
I hope this will work for you.