topic Re: Set Analysis doesn't (seem to) work in Aggr() in App Development

Set Analysis doesn't (seem to) work in Aggr()

GregWP — Mon, 04 Nov 2019 05:19:49 GMT

Hi,

I have this simple example where I want to always display every month regardless of selection. I tried a calculated dimension using Aggr() but it has no effect -

=Aggr({1} MaxString({1} YrMth), YrMth)

I imagined this would return every YrMth but if I select a project it only returns those months with a related transaction. What am I misunderstanding?

Primarily I want a trend chart without missing months.

Would appreciate any help.

Re: Set Analysis doesn't (seem to) work in Aggr()

jyothish8807 — Mon, 04 Nov 2019 06:25:46 GMT

Hi GregWP,

Try this:

=Aggr(MaxString({1<Project= >} YrMth), YrMth)

if you have more fields like project, then add them also into the set analysis.

Br,

Re: Set Analysis doesn't (seem to) work in Aggr()

GregWP — Mon, 04 Nov 2019 06:45:06 GMT

Thanks KC, but I do want selection by other fields, e.g. see the trend over time for 'Project One'. What I'm looking for is for all the Year-Month values to display regardless of selections. This will form the x-axis of a bar chart.

Currently it ignores selection on YrMth itself but if I select Project it reduces to just the set of related transaction records.

Re: Set Analysis doesn't (seem to) work in Aggr()

jyothish8807 — Mon, 04 Nov 2019 07:01:39 GMT

May be this help:

Modify your expression as below, keep all dimensions as it is:

sum(Amount)+0*sum({1}Amount)

Br,

Re: Set Analysis doesn't (seem to) work in Aggr()

GregWP — Mon, 04 Nov 2019 09:12:08 GMT

Thanks KC,

I shortened this to + Sum({1} 0 )

Re: Set Analysis doesn't (seem to) work in Aggr()

jyothish8807 — Tue, 05 Nov 2019 09:37:48 GMT

Great ! Please close the thread by marking the right answer 🙂

Br,