Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I had cumulative values for each player ID so I used the script to only get the max value per Game_Date as shown below. That is the max value repeated per row for one player per date.
I can get the distinct for each player and sum them as a single row in a straight table with Dimensions reducing the data then using
=sum({<HOME_TEAM_NAME = , AWAY_TEAM_NAME, GAME_DATE, LAST_NAME>}aggr(Only({<PLAYERTEAMNAME2={'$(vTeam2)'},HOME_TEAM_NAME = , AWAY_TEAM_NAME = ,GAME_DATE =, LAST_NAME = >} MAX_VERY_HIGH_SPEED_TIMES),MAX_VERY_HIGH_SPEED_TIMES))
My issue is that if multiple players have the same max value like above, the 'duplicates' are ignored when I try to use it as an expression to create just the total in a row (or text object).
Is it possible to take the distinct value per player per game, then sum them all without the distinct function removing duplicates?
May be you need this
=Sum({<HOME_TEAM_NAME, AWAY_TEAM_NAME, GAME_DATE, LAST_NAME>} Aggr(
Only({<PLAYERTEAMNAME2 = {'$(vTeam2)'}, HOME_TEAM_NAME, AWAY_TEAM_NAME, GAME_DATE, LAST_NAME>} MAX_VERY_HIGH_SPEED_TIMES)
, GAME_DATE, LAST_NAME))
May be you need this
=Sum({<HOME_TEAM_NAME, AWAY_TEAM_NAME, GAME_DATE, LAST_NAME>} Aggr(
Only({<PLAYERTEAMNAME2 = {'$(vTeam2)'}, HOME_TEAM_NAME, AWAY_TEAM_NAME, GAME_DATE, LAST_NAME>} MAX_VERY_HIGH_SPEED_TIMES)
, GAME_DATE, LAST_NAME))
Thank you very much, that is exactly what I needed.