This content has been marked as final.
Show 3 replies
-
1. Re: Help with level of detail expression
Simon RuncJun 13, 2016 9:03 AM (in response to Patrick T)
hi Patrick,
Hopefully this will do the trick...
I've added a new %age calculation
[% of records LoD]
sum([Number of Records])/SUM({FIXED [Calldate]: SUM([Number of Records])})
As the LoD is immune to regular dimension filtering, it means that regardless of the filter it *should* still be correct. I'e added it into the tooltip so you can see what it's doing.
Let me know if that isn't what you were after, or doesn't make sense
-
Fixed LoD - filter immune.twbx 388.8 KB
-
-
2. Re: Help with level of detail expression
KK Molugu Jun 13, 2016 9:10 AM (in response to Simon Runc)Beat me to the second Simon... Good solutions
..kk
-
3. Re: Help with level of detail expression
Patrick T Jun 13, 2016 9:22 AM (in response to Simon Runc)Lol, thanks. I came up with the same solution right now while out on a walk. Very much appreciated.