My expectation that the ultimate goal is the normalization of client names across products / datasets for simple reporting. For example, consider the following fictitious example: Webroot: Client Count CompanyOne 10 CompanyTwo 20 Sentinel One: Client Count Company-One 5 Company-Two 15 Mapping: ConnectWise Manage Webroot Sentinel One Company One CompanyOne Company-One Company Two CompanyTwo Company-Two Sample Report: Client Weboot Sentinel One Company One 10 5 Company Two 20 15 With this reporting dataset, slicers would work as long as the source of the names were the Manage clients. When I look at most of the datasets, I would expect to see the “native” client name and an alternate “Mapped” client name. For reporting purposes, we’d standardize on the mapped version.
