I have a database with each row containing details of an attack done by one of the players.
I figure how to use TPO() and SELECT() to present statistics from the last X attacks.
I need to present statistic of the last X attacks and X is a variable I wanโt users to be able to change in real time , if this is not possible I could set up a table with the parameter and use it in the formulas?
This is the formula i have in a slice filter to select only players that have more tha 4 attacks. : count(SELECT(row2[Punteggio Globale], [Nome] = [Name]))>4
Can I put a variable in the place where number 4 is?
Furthemore
i have a player tab with a virtual column that calculate average point for the last 10 attacsk:
average(top(SELECT(Row2[Punteggio Globale], ([_THISROW].[Nome] = [Name]), FALSE),10))
I wanted to make that 10 attacks somethink that user can modifiy and for example try what is the results if they put a 5 instead of the ten.
If there would be variables i would write something like this:
average(top(SELECT(Row2[Punteggio Globale], ([_THISROW].[Nome] = [Name]), FALSE),VARIABLE))
User | Count |
---|---|
38 | |
31 | |
30 | |
17 | |
16 |