3 Replies Latest reply on Feb 7, 2017 2:14 PM by Tommy Sims

    Count Distinct with blended sources

    Tommy Sims

      I'm pretty stumped on this one. Have 2 sources in server that I am blending. One with all accounts that have run a report and another that has all accounts ever. These accounts exist in a hierarchy of channel, region, etc... I need count distinct from both sources so that I can show for example "Channel A had 30 of their 100 accounts run the report". Basically to show a % coverage. I continue to receive the red error pill when bringing in count distinct of account from the secondary source. Is there any workaround here? I have tried nearly every solution I have seen on the forums with no luck.