Comapre two tables

[segerchr]

Hi@all,

i am searching for a peace of code which compares two tables and shows the average of the trainigsvisits.

Tabel1 (Players):

PlayerID     Name     Name2     Foot     Age    

ID_001       Tom        Smith       Right     24

ID_002        Sarah     Coy         Left       31

***

Table2 (Games):

PlayerID     GameID          Time              Lesson

ID_001        Game_01       2016-12-01     1

ID_002        Game_01       2016-12-01     1

ID_001       Game_02        2016-12-08     2

How can i compare if every player visited the each gameIDs.

So i will display for Game_01 / 100% for Game_02 / 50 % and so on.

Thanks

CS

[sunny_talwar]

May be this:

GameID as dimension

and expression -> =Count(PlayerID)/Count(TOTAL DISTINCT PlayerID)

[segerchr]

Hey thanks for your answer. Is it also possible to show the avg of all trainingsvisits in a cake diagramm ?

Thank for helping.

BR

CS

[sunny_talwar]

Cake diagram? Do you mean a pie chart or is this another diagram?

[segerchr]

I mean a pie 

[sunny_talwar]

Like this?

[segerchr]

Hi,

thanks for your answer again. The measure should be the avg(of the Game01 % and the Game02 %). In this case 75%.

The pie should only display 75%.

Thanks for helping.

[sunny_talwar]

What about the other 25%? It just won't be visible?

[segerchr]

It should also be visible in another color. The same diagram like above, only with the avg of the trainings percents.

Thanks a lot

[sunny_talwar]

Like this?