Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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