Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a line chart with Dimension
If(Date > '7/15/2018',Date)
and measure Sum(Sales)
I am wondering what is more optimal performance wise using my calculated dimension or using set analysis
Sum({<[Date] = {'>7/15/2018'}>}Sales)
I know the best thing to do would be create a flag in my script for Date > 7/15 and use that in my Set Analysis but its not always feasible to have so many flags.
Thanks!
Mark
Thank you for your response. Could you explain further what you mean by
'the reason is that your if statement gets calculated for each line which means it doesn't get cached.
while set analysis gets calculated once.'