Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
GameID as dimension
and expression -> =Count(PlayerID)/Count(TOTAL DISTINCT PlayerID)
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
Cake diagram? Do you mean a pie chart or is this another diagram?
I mean a pie
Like this?
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.
What about the other 25%? It just won't be visible?
It should also be visible in another color. The same diagram like above, only with the avg of the trainings percents.
Thanks a lot
Like this?