Countunique with reference to another table

#1

Hi,

currently I build a skill tracker to keep an overview, who learned what in my team.

The core table looks like this:

I use some extra tables for reporting. One of them looks like this:
2019-04-16%2010_28_59-DACH%20Skill%20%26%20Training%20Map

In the 2nd table I would like calculate the “agents trained” column. Here I would summarize, how many agents have been listed for each topics (so unique name counts).

e.g.:

  • Logistics: 6 people
  • Security: 3 people

Why unique?
Every agents has several skills to be trained on and has several rows within a topic with his name listed in the core table.

I tried this formula:
[Complete Data Base].Filter([Complete Data Base].Topic= thisRow.Topic).Countunique([Complete Data Base].Name)

But it only shows all unique agents in every row… The Topic filter does not impact the result here.

Any idea on how to solve this problem?

0 Likes

#2

@Thomas_Meissner

Something like this maybe?

[complete db].Filter(topic=thisRow).name.CountUnique()

0 Likes

#3

@Ander
I tried it like this:
2019-04-16%2015_09_18-DACH%20Skill%20%26%20Training%20Map

Unfortunately it only results in a “0”.

Do you have an idea why?

0 Likes

#4

Ah,

I found two mistakes…
1.) In table 2 Topic was not a select list like in table 1.
2.) Instead of “this row” I needed to enter “Topic” from table 2. Then it worked.

Thanks for your help!

1 Like

#5

@Thomas_Meissner

EDIT: I was just about to post when I saw your update. I’ll leave this here as a visual aid for others.


It looks like there are one or more data type mismatches. Compare the data types indicated by your formula tokens, to those in the embedded doc:

0 Likes