I have 2 visualizations: 1- Bar chart where I count distinct all the agencies that made more than X sells, break down by group 2- Time Graph where I count distinct all the agencies that made more than X sells by the mont

The problem is that I have agencies that work with more than one group, so in the bar chart, I will distinct count them for each group, while on the time graph I distinct count them only once.

The number of agencies in the bar chart is 64 and on the time chart is 58...

I tried to use a LOD calculation for the time graph but the number still doesn't match.

Would love to get help with this one :-)

Thanks!

Yaron