topic Re: Filter down to the individual and show the average for its associated team in App Development

Filter down to the individual and show the average for its associated team

kamaker — Tue, 05 Dec 2023 20:11:19 GMT

I am creating an app where an individuals results are compare to their team's results. I have a dataset of mileage statistics for individuals along with their team name. In my app I have a filter pane for the individual. I want to show the individual's average miles and their team's overall average mileage. I know I need to use set analysis but I can not figure out how to do the team average instead of everyone's average mileage.

formulas:

Individual: Avg(miles)

Team: Avg({1 <[team name]>}miles)

The issue is that the team is everyone's average mileage and not just that team's average mileage.

Re: Filter down to the individual and show the average for its associated team

Aasir — Wed, 06 Dec 2023 03:26:30 GMT

For Individual's Average Miles: Avg({<Individual = {"$(=GetCurrentField(Individual))"}>} miles)

For Team's Average Miles: Avg({<Team = {"$(=GetCurrentField(Team))"}>} miles)

Re: Filter down to the individual and show the average for its associated team

kamaker — Mon, 11 Dec 2023 16:10:37 GMT

Unfortunately it did not work. The KPI stayed as a '-' for both formulas.

Re: Filter down to the individual and show the average for its associated team

kamaker — Mon, 11 Dec 2023 16:22:21 GMT

I tried to use GetFieldSelection but it filters down to the person's average and not just the team's average.

Re: Filter down to the individual and show the average for its associated team

vincent_ardiet_ — Mon, 11 Dec 2023 16:29:42 GMT

For the individual Avg(miles) is working right?

For the team (according that the field you are filter on is called [Individual Name], this should do the trick:
Avg({<[Individual name]=,[team name]=p([team name])>}miles)