Hi Community,
I am new to QV.
Hope anybody could help me please !!
I have a requirement to build the model and Dashboards
Requirements : in metrics/KPI's
1.Count of Unique Stores by User
2.Count of Unique Users
3.Total stores visited(actual)
4.Total stores should be visited
5.Pending Stores remained to visit
Below are the sample tables
Main Transaction table |
ID | User | Date | Product |
abc111 | Lucy | 1/06/2015 | Pdc111 |
abc111 | Lucy | 1/06/2015 | Pdc112 |
abc112 | Lucy | 1/06/2015 | Pdc113 |
abc112 | Lucy | 1/06/2015 | Pdc114 |
abc113 | Lucy | 1/06/2015 | Pdc115 |
abd114 | Sean | 1/06/2015 | Pdc116 |
abd114 | Sean | 2/06/2015 | Pdc117 |
abd115 | Sean | 2/06/2015 | Pdc118 |
abd116 | White | 2/06/2015 | Pdc119 |
abc116 | White | 2/06/2015 | Pdc120 |
abc117 | White | 4/06/2015 | Pdc121 |
abc117 | White | 4/06/2015 | Pdc122 |
Detail(Unique) |
ID | Store |
abc111 | Australia |
abc112 | America |
abd114 | Dubai |
abc116 | - |
abc117 | - |
abc118 | Thailand |
Lookup(Stores allocated to each user) |
User | Stores |
Lucy | Australia |
Lucy | America |
Lucy | Austria |
Sean | Dubai |
Sean | UK |
Sean | Nizeria |
White | Singapore |
White | Malaysia |
White | Thailand |
Thanks in Advance...