Forum Discussion

tyeriksen's avatar
tyeriksen
Frequent Visitor
5 years ago

Visualisation Top N filter needs value 27 to result 5.

Hi all, I have a visualisation of 200+ athletes, where I want to show top N = 5.    First, the qualifying criteria: AB>150 Seasons>2   All good so far:       When I filter Name by top...
General Comment
Need Help
v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi tyeriksen ,

 

It may be because your AVG measure returns null values in some rows.

If not, please provide sample data.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

tyeriksen's avatar
tyeriksen
Frequent Visitor
5 years ago

Hi v-lionel-msft , unfortunately thats not the case. 


Not a problem to share my file, its public info. The problem can be observed on
Page 'Leaderboard Pitchers' in all ratio tables (e.g. K/IP, ERA, WH/IP, H/IP, BB/IP, OAVG, etc)

Page 'Leaderboard Batters' in all ratio tables (e.g. Slugging Pct. , Batting Avg.)

 

Also having issues with the same type of problem of top N filtering on the page 'Regular Season Batting Records', where Im unable to get a top 5 by Name, regardless of any filter allocation I try (year, league, name, statistic category, etc...)


https://1drv.ms/u/s!Alr9NCLvEz89vlnZ92vqADFIgQmX?e=9xTsSL

Thanks!