cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

LineChart grouping and averaging

Hi,

I have a table as follows:

SatisfactionValueEnvironmentTeamDate
889A10/03/2019
389B09/03/2019
741A11/03/2019
333A11/03/2019
101010B11/03/2019

 

and want to create a graph to summarize that information....grouping and averaging by team and date, and filtering by Team.

So the final table should look like this:

 

SatisfactionValueEnvironmentTeamDate
889A10/03/2019
53,52A11/03/2019
741B09/03/2019
333B11/03/2019

 

but the graph should only show team A or B depending on user selection.

I have been playing with the Items property of my LineChart, but can't make it work.

 

Any ideas?

Thanks!

M.

2 REPLIES 2
Highlighted
Super User
Super User

Re: LineChart grouping and averaging

@milincheta 

Not sure what your GroupBy formula looks like, but you can simply apply a Filter to the Datasource that is the core of that GroupBy.  Ex:

   GroupBy(Filter(yourDataSource, Team="A"), ...

 

Of course you'd probably have this team information come from a dropdown or other source, but you'd just need to replace the Team="A" with the Team=yourControl-value

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Highlighted
Frequent Visitor

Re: LineChart grouping and averaging

Hi @RandyHayes , 

thanks for your answer. Forgetting for a moment the filtering...

My group by looks like:

GroupBy(TeamSurvey;"Value";"Satisfaction";"Environment";"Date";"Col") and the result is

one data point per row on my table, not one per month averaging.

Sorry this is not allowing me to attach images.

What I need is to average and group by month, so I can show the average value for each month.

Thanks for your help!

M.

Helpful resources

Announcements
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,799)