Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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,
KC
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.
May be this help:
Modify your expression as below, keep all dimensions as it is:
sum(Amount)+0*sum({1}Amount)
Br,
KC
Thanks KC,
I shortened this to + Sum({1} 0 )
Great ! Please close the thread by marking the right answer 🙂
Br,
KC