topic Re: Aggr Function Help in App Development

Aggr Function Help

jheasley — Wed, 15 Jan 2020 18:28:41 GMT

I am having trouble getting the Total number of hours to aggregate by Time Period. I need the total hours for a time period to compare to the total number of hours per region and time period.

for Jan 2020 I need each regions Recent Total to show 102, for Dec 2019 I need 176, etc.

I am currently using:

Sum({<[_recent]={1}>}Aggr(Sum({<[_recent]={1}>}timeSpentSeconds_u0),[Worklog Month])/60/60)

if i add the dimension of region, the totals in both columns are the same.

Re: Aggr Function Help

Kushal_Chawda — Wed, 15 Jan 2020 19:34:03 GMT

may be this Sum(total <[Working Month]>{<[_recent]={1}>}Aggr(Sum({<[_recent]={1}>}timeSpentSeconds_u0),[Worklog Month])/60/60)

Re: Aggr Function Help

juraj_misina — Wed, 15 Jan 2020 20:07:04 GMT

Optionally I think in this case it is legal to use

Sum({<[_recent]={1}>}Aggr(NODISTINCT Sum({<[_recent]={1}>}timeSpentSeconds_u0),[Worklog Month])/60/60)

Hope this helps.

Juraj.

Re: Aggr Function Help

jheasley — Thu, 23 Jan 2020 12:50:49 GMT

same result that i got

Re: Aggr Function Help

jheasley — Thu, 23 Jan 2020 12:52:53 GMT

this didnt work either. attached is the result for both options.

Re: Aggr Function Help

lorenzoconforti — Thu, 23 Jan 2020 14:56:45 GMT

I think there might be a spelling mistake in one of the formulas; try

Sum(total <[Worklog Month]>{<[_recent]={1}>}Aggr(Sum({<[_recent]={1}>}timeSpentSeconds_u0),[Worklog Month])/60/60)

Re: Aggr Function Help

juraj_misina — Thu, 23 Jan 2020 16:07:14 GMT

Hi @jheasley Both work for me, see attached app.