topic Re: average YTD as at x month in a table in App Development

average YTD as at x month in a table

Anonymous — Thu, 21 Jun 2018 00:39:40 GMT

Hi,

I would like to build a line chart that displays average score YTD as at X month as below

The raw data looks like this

The desired outcome is as follows

Year-Month Average Score

Jan 2016 Avg(Jan 2016)

Mar 2016 Avg(Jan-Mar 2016)

Jan 2017 Avg(Jan 2017)

Dec 2017 Avg(Jan-Dec 2017)

I have been trying to use set analysis formula but failed, probably my coding is not right. Can someone help me?

The sample data set is attached in excel

sunny_talwar — Thu, 21 Jun 2018 12:01:43 GMT

Try using this expression

Aggr(RangeSum(Above(Sum(Score), 0, RowNo()))/RangeSum(Above(Count(Id), 0, RowNo())), Year, Month)

Anonymous — Fri, 22 Jun 2018 00:44:35 GMT

Thank Sunny,

Is there any way I can do it using Avg and set analysis expression for this problem?

sunny_talwar — Fri, 22 Jun 2018 02:45:49 GMT

Average might work, but why set analysis? not sure I understand? Is something not working with the current expression?