Skip to Content
Jul 24, 2019 at 07:21 PM

Counting the same data from two data sources

37 Views Last edit Jul 24, 2019 at 07:22 PM 2 rev

We have a universe that connects to a live database for employee information. Within that same universe, we have a folder that contains objects from an imported Excel file for termination information.

I have a simple Count([Employee]) formula to count the number of terms from the Excel file and another Count([ID]) formula to count the number of current employees, as noted in the two charts below. Within the first chart, there is a ranking to only show the top ten based on count.

I am trying to show the percentage of our current population beside the term number - essentially taking the 17.43% and displaying it beside the 169 number, but keeping the rank still based on top 10 term positions. Since these numbers are from two different data sources, I'm not sure how to accomplish this. I tried a merged dimension of Position Title, since that's a field in both data sources and consistent, but that didn't work.

Can someone point me in the right direction?


picture1.png (43.2 kB)