Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am trying to make the expression below return the full data set. I have put the set identifier {1} in all of the places it might need to be on aggregation functions. However in the app it still only brings back the current selections. I think that it must be because of the fields the aggr functions is working on, especially [Unique ID] but I dont know how to fix it. Any ideas please? max({1} aggr(sum({1}aggr([Savings]*((round(avg({1} [Question Response]))-1)/4),[Question Number], [Unique ID])),[Unique ID]))
Thanks to all of you who helped on this
I put this back in the scatter chart and it turned out that the problem all along had been that I had not put any set analysis on the other dimension