LineChart grouping and averaging

[Anonymous]

Hi,

I have a table as follows:

Satisfaction	Value	Environment	Team	Date
8	8	9	A	10/03/2019
3	8	9	B	09/03/2019
7	4	1	A	11/03/2019
3	3	3	A	11/03/2019
10	10	10	B	11/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:

Satisfaction	Value	Environment	Team	Date
8	8	9	A	10/03/2019
5	3,5	2	A	11/03/2019
7	4	1	B	09/03/2019
3	3	3	B	11/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.

[RandyHayes]

@Anonymous 

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.

[Anonymous]

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.