Calculation Performance

Thu, 01 Dec 2016 10:27:44 GMT

May be an interesting debate, I have just took over a QV dashboard and from looking at the calcs it has raised this question in my head.

One of the calcs,

sum(if([Year]='2016'and [Week]='1',[Age]))

I would have written as

Sum({$<Year={$(=2016)},Week={$(=1)}>}Age)

Which version of the calc would you say is the best for the overall performance of the dashboard? and to expand my knowledge why?

Re: Calculation Performance

sunny_talwar — Thu, 01 Dec 2016 10:29:43 GMT

I would use set analysis, but with slight changes

Sum({<Year = {2016}, Week = {1}>} Age)

This because set analysis is evaluated once per chart and should lead to some better performance